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
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
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
"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
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
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?
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,
> >
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
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
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
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
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.
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 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.
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
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
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
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
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
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 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
21 matches
Mail list logo
