On 20 August 2012 19:34, Evil wrote:
> Hello List,
> First time here also beginner to Postgres.So please forgive me for any
> mistakes.
> I'm pretty sure i have same problem.=>
> http://archives.postgresql.org/pgsql-admin/2012-03/msg00105.php
> (After searching it i found it)
> However it is not s
first_value refers to the first row from the window frame. Unless you force
some kind of ordering, you cannot expect
consistent results out of this.
See the PARTITION BY ... ORDER BY syntax in
http://www.postgresql.org/docs/9.1/static/tutorial-window.html
On Δευ 20 Αυγ 2012 01:55:38 Thalis Kal
On 08/21/2012 02:34 AM, Evil wrote:
After issusing that revoke from public my postgres user still able to
connect to any database.
Looking at your logs, you tested to see if they could connect to a
database named "onlypostgres", but I didn't see any sign that you had
REVOKEd connect from publ
Hi Tom,
and thanks for the reply (I had the pleasure of meeting you 11 years ago in
Pittsburgh; still a pleasure seeing your concise and helpful replies.)
In the end I went for a change of window function. Using "min(insertedon)"
instead of "first_value(insertedon)" works correctly.
Alternativel
Hello,
Since Amazon has added new high I/O instance types and EBS volumes, anyone
has done some benchmark of PostgreSQL on them ?
http://perspectives.mvdirona.com/2012/07/20/IOPerformanceNoLongerSucksInTheCloud.aspx
http://perspectives.mvdirona.com/2012/08/01/EBSProvisionedIOPSOptimizedInstanceTy
Sebastien Boisvert writes:
> Is this mechanism documented anywhere (besides source code)?
No, not really.
> It looks like PG will only clean it up if there's no other process running at
> all on the pid listed in the postmaster.pid file, even if any process running
> on that pid isn't a PG pro
Is this mechanism documented anywhere (besides source code)?
It looks like PG will only clean it up if there's no other process running at
all on the pid listed in the postmaster.pid file, even if any process running
on that pid isn't a PG process or there's no server running on the data
direct
On 08/21/2012 03:06 AM, Martijn van Oosterhout wrote:
I'm not sure I have an opinion on pushing ORM features to the database
layer, SQLAlchemy is doing a pretty good job for me already.
There are some things ORMs could really use help from the database with,
though. Particularly when fetching
On Mon, Aug 20, 2012 at 2:33 PM, John R Pierce wrote:
> On 08/20/12 11:46 AM, elliott wrote:
>>
>> envdb=# \d astgtm2_n60e073;
>> Table "public.astgtm2_n60e073"
>> Column | Type | Modifiers
>> +-+---
>> lat| real|
>> lon| real|
>> alt| integer |
>
Howdy folks,
Does anyone know if its possible to use entity framework code first with
the npgsql connector? I know devart's connector does the job, but I'm low
on funds for this project and their stuff is not cheap.
Any help would be appreciated.
On 08/20/12 11:46 AM, elliott wrote:
envdb=# \d astgtm2_n60e073;
Table "public.astgtm2_n60e073"
Column | Type | Modifiers
+-+---
lat| real|
lon| real|
alt| integer |
Indexes:
"q3c_astgtm2_n60e073_idx" btree (q3c_ang2ipix(lon, lat)) CLUSTER
On Sun, Aug 19, 2012 at 06:28:57PM -0700, Chris Travers wrote:
> In DB2 this might be done like:
>
> SELECT * FROM address WHERE address->country->short_name = 'US';
>
> I like DB2's approach better because there is no ambiguity between
> namespace resolution but I don't entirely like the way the
envdb=# \d astgtm2_n60e073;
Table "public.astgtm2_n60e073"
Column | Type | Modifiers
+-+---
lat| real|
lon| real|
alt| integer |
Indexes:
"q3c_astgtm2_n60e073_idx" btree (q3c_ang2ipix(lon, lat)) CLUSTER
On 8/20/2012 2:10 PM, John R Pierce wr
> -Original Message-
> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-
> ow...@postgresql.org] On Behalf Of elliott
> Sent: Monday, August 20, 2012 1:54 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] Database Bloat
>
> Hi,
>
> I am using PostgreSQL 9.1 and load
On 08/20/12 10:53 AM, elliott wrote:
Hi,
I am using PostgreSQL 9.1 and loading very large tables ( 13 million
rows each ). The flat file size is only 25M. However, the equivalent
database table is 548MB. This is without any indexes applied and auto
vacuum turned on. I have read that the
On Mon, Aug 20, 2012 at 10:29 AM, Steven Schlansker wrote:
>
> On Aug 19, 2012, at 2:37 PM, Jeff Davis wrote:
>
>> On Tue, 2012-07-10 at 00:09 -0700, Steven Schlansker wrote:
>>> show that our particular application is faster by quite a bit when a
>>> hash index is available.
>>
>> Can you publis
Hi,
I am using PostgreSQL 9.1 and loading very large tables ( 13 million
rows each ). The flat file size is only 25M. However, the equivalent
database table is 548MB. This is without any indexes applied and auto
vacuum turned on. I have read that the bloat can be around 5 times
greater f
Sebastien Boisvert writes:
> I vaguely remember reading in the release notes (around the time 9.x was
> released) something about it automatically clearing out the postmaster.pid
> file if it was found to be stale/invalid when starting the the database
> server, however I cannot find any refere
On Aug 19, 2012, at 2:37 PM, Jeff Davis wrote:
> On Tue, 2012-07-10 at 00:09 -0700, Steven Schlansker wrote:
>> I understand that the current wisdom is "don't use hash indices", but
>> (unfortunately?) I have benchmarks that
>> show that our particular application is faster by quite a bit when a
On Aug 19, 2012, at 8:01 PM, Scott Marlowe wrote:
> On Tue, Jul 10, 2012 at 1:09 AM, Steven Schlansker
> wrote:
>> I'm using Postgres hash indices on a streaming replica master.
>> As is documented, hash indices are not logged, so the replica does not have
>> access to them.
>>
>> I understa
I vaguely remember reading in the release notes (around the time 9.x was
released) something about it automatically clearing out the postmaster.pid file
if it was found to be stale/invalid when starting the the database server,
however I cannot find any reference to this anymore.
Was this somet
On Fri, 17 Aug 2012 08:53:05 -0400
Moshe Jacobson wrote:
> I do not know of anything that can't be done from within psql.
> We use non-privileged user roles in postgres for day-to-day
> operations. When I need to modify the schema, I become postgres (you
> can do \c - postgres) and do what I need
Thalis Kalfigkopoulos writes:
> # SELECT id, experiment, first_value(insertedon) OVER (PARTITION BY score,
> id) AS first_insertedon, score FROM data WHERE id=1160;
> [ versus ]
> # CREATE VIEW clustered_view AS SELECT id, experiment,
> first_value(insertedon) OVER (PARTITION BY score, id) AS fi
On Mon, Aug 20, 2012 at 9:59 AM, Andreas Kretschmer
wrote:
> salah jubeh wrote:
>
>> Hello Andreas,
>>
>> Thanks for the reply, The example I have posted is very simple and you are
>> right it is very similar to select max (id) from table_that_does_not_exist;
>> But
>> there are more here, for
salah jubeh wrote:
> Hello Andreas,
>
> Thanks for the reply, The example I have posted is very simple and you are
> right it is very similar to select max (id) from table_that_does_not_exist;
> But
> there are more here, for example imagine I have something like
>
> CREATE VIEW a4 as select
On Mon, Aug 20, 2012 at 9:37 AM, salah jubeh wrote:
> Hello Andreas,
>
> Thanks for the reply, The example I have posted is very simple and you are
> right it is very similar to select max (id) from table_that_does_not_exist;
> But there are more here, for example imagine I have something like
>
Hello Andreas,
Thanks for the reply, The example I have posted is very simple and you are
right it is very similar to select max (id) from table_that_does_not_exist;
But there are more here, for example imagine I have something like
CREATE VIEW a4 as select from a3(), ;
In my op
On Sun, Aug 19, 2012 at 8:14 AM, Dmitriy Igrishin wrote:
>> For various reasons, this often goes the wrong way. Views are often
>> the right way to go. +1 on your comment above -- the right way to do
>> views (and SQL in general) is to organize scripts and to try and avoid
>> managing everything
salah jubeh wrote:
> Hello Guys,
>
> I am having a scenario close to the one below, I have defined a function which
> depends on a view. I am able to drop the view, but my server did not complain
> about the dependency.
>
> In the scenario below, one can drop the views a2 and a1 respectively,
Hello Guys,
I am having a scenario close to the one below, I have defined a function which
depends on a view. I am able to drop the view, but my server did not complain
about the dependency.
In the scenario below, one can drop the views a2 and a1 respectively, and when
executing a3(), certa
On Thu, Aug 16, 2012 at 04:04:48PM +0200, Wolfgang Keller wrote:
> > I could not get the script sqlalchemy_schemadisplay3.py to work with
> > sqlalchemy 0.7.8-1 (on Debian).
>
> Have you asked on the SQLalchemy mailing list?
No.
Thanks for the link.
Regards
Johann
--
Johann Spies
On Wed, 2012-07-18 at 14:33 -0700, Scott Bailey wrote:
> I'm testing range types and I've come up with a couple of curiosities.
>
> 1) I'll start off easy. In the wild, discrete ranges tend to be
> closed-closed [] while continuous ranges tend to be closed-open [). For
> instance, on Tuesday sto
32 matches
Mail list logo
