On Tue, Nov 27, 2012 at 6:59 AM, Kevin Grittner wrote:
> wd wrote:
>
>> the time is between backup start and stop.
>
> That is the problem -- until the point where pg_stop_backup() was
> run PostgreSQL can't be sure of having a consistent database.
In 9.2, it seems to be willing to give it a shot
Em 27-11-2012 19:50, David Johnston escreveu:
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rodrigo Rosenfeld
Rosas
Sent: Tuesday, November 27, 2012 4:23 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] distinct values and count over windo
On Fri, Nov 23, 2012 at 2:39 AM, Peter Kroon wrote:
> Is pgsql faster on linux?
> Currently I've made an installation on W7 and the converted queries are
> about 3 times slower then on mssql.
> There's still some optimization to do tho...but the current results don't
> look to good.
Wait first yo
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Rodrigo Rosenfeld
Rosas
Sent: Tuesday, November 27, 2012 4:23 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] distinct values and count over window function
Hello, this is my first post to thi
Hello, this is my first post to this particular list (I've also posted
to performance list a while ago to report a bug).
I generate complex dynamic queries and paginate them using "LIMIT 50". I
have a need for implementing some statistics for the results as well and
I'd like to know if I can a
Hello,
In Postgresql 9.2 this function pg_listening_channels() returns the channels
that the current session/connection listens to.
How (if it's even possible) can I get listening channels for all sessions/
connections in the database?
With older versions I could just query "pg_listener WHERE r
On Wed, Nov 28, 2012 at 09:21:02AM +1300, Gavin Flower wrote:
> Why should Postgres bother to order records in any particular way,
> unless the user has explicitly requested an order?
More importantly, since SQL results are sets (not ordered sets),
it is plain out required to request an order if y
On 27/11/12 14:23, classical_89 wrote:
Thanks , i just want to get a correlation of near 0 to understand exactly
what correlation , i quite ambiguity about this concept . /
Statistical correlation between physical row ordering and logical ordering
of the column values. This ranges from -1 to +1.
PostgreSQL 9.2 on Windows Server 2008 R2 64-bit
Streaming Replication initialised & working on a 500GB database.
Following day on slave, following errors in the log:
2012-11-27 09:57:53 GMT WARNING: page 911726 of relation
pg_tblspc/16570/PG_9.2_201204301/16571/16595 is uninitialized
2012-11-27
On Tue, Nov 27, 2012 at 6:59 AM, Kevin Grittner wrote:
> wd wrote:
>
>> the time is between backup start and stop.
>
> That is the problem -- until the point where pg_stop_backup() was
> run PostgreSQL can't be sure of having a consistent database. It is
> waiting from enough WAL to get it there.
On Tue, Nov 27, 2012 at 10:06 AM, Seref Arikan wrote:
> I have a function that creates a temp table, inserts rows into it, performs
> joins, and returns a single integer as a result. This is pg 9.1. All
> sessions are using the exact same temp table structure.
> re performance requirements: I need
Hari Babu writes:
> There is a file in postgres\src\bin\pgevent\MSG1.bin,
> For the internal usage purpose, the MSG1.bin file is changed to
> MSG1.msg and updated pgmsgevent.rc file accordingly.
> As we cannot deliver the *.bin files to the customer.
Why not? Such a change seems
I have a function that creates a temp table, inserts rows into it, performs
joins, and returns a single integer as a result. This is pg 9.1. All
sessions are using the exact same temp table structure.
re performance requirements: I need this function to return as fast as
possible :) On a production
On Tue, Nov 27, 2012 at 9:44 AM, Seref Arikan wrote:
>> > Also I need those tables per session, so creating and dropping with TEMP
>> > tables appear to be faster.
>>
>> Performance of creating tables is going to be storage bound. what are
>> your performance requirements? Even if the temp table
Hi Merlin,
See below please
On Tue, Nov 27, 2012 at 3:29 PM, Merlin Moncure wrote:
> On Fri, Nov 23, 2012 at 4:09 AM, Peter Kroon wrote:
> > I've put up a small test case for creating TEMP and UNLOGGED tables.
> > DROP TABLE IF EXISTS test CASCADE;
> > CREATE TEMP TABLE test(
> > id serial,
> >
There is a file in postgres\src\bin\pgevent\MSG1.bin,
For the internal usage purpose, the MSG1.bin file is changed to
MSG1.msg and updated pgmsgevent.rc file accordingly.
As we cannot deliver the *.bin files to the customer.
Is there any problem with the above modification?
On Fri, Nov 23, 2012 at 4:09 AM, Peter Kroon wrote:
> I've put up a small test case for creating TEMP and UNLOGGED tables.
> DROP TABLE IF EXISTS test CASCADE;
> CREATE TEMP TABLE test(
> id serial,
> the_value text
> );
> Exec time: 54ms
>
> DROP TABLE IF EXISTS test CASCADE;
> CREATE UNLOGGED TA
"Kevin Grittner" writes:
> That is the problem -- until the point where pg_stop_backup() was
> run PostgreSQL can't be sure of having a consistent database. It is
> waiting from enough WAL to get it there. My practice is always to
> keep the last two base backups and all WAL from the start of the
wd wrote:
> the time is between backup start and stop.
That is the problem -- until the point where pg_stop_backup() was
run PostgreSQL can't be sure of having a consistent database. It is
waiting from enough WAL to get it there. My practice is always to
keep the last two base backups and all WAL
Thanks , i just want to get a correlation of near 0 to understand exactly
what correlation , i quite ambiguity about this concept . /
Statistical correlation between physical row ordering and logical ordering
of the column values. This ranges from -1 to +1. When the value is near -1
or +1, an index
On Mon, 2012-11-26 at 18:56 +, Mark Volz wrote:
> Hello,
>
> I created a role called Workers. I am able edit the privileges for the
> Workers role in the public schema of a database. I also would like to edit
> the default privileges of the schema as well so that the Workers group will
> a
21 matches
Mail list logo
