On 19/08/2010 12:23, Philippe Rimbault wrote:
On 19/08/2010 11:51, Scott Marlowe wrote:
On Thu, Aug 19, 2010 at 2:07 AM, Philippe Rimbault
wrote:
Hi,
I'm having a strange performance result on a new database server
compared to
my simple desktop.
The configuration of the new s
On 19/08/2010 11:51, Scott Marlowe wrote:
On Thu, Aug 19, 2010 at 2:07 AM, Philippe Rimbault wrote:
Hi,
I'm having a strange performance result on a new database server compared to
my simple desktop.
The configuration of the new server :
- OS : GNU/Linux Debian Etch x
Hi,
I'm having a strange performance result on a new database server
compared to my simple desktop.
The configuration of the new server :
- OS : GNU/Linux Debian Etch x86_64
- kernel : Linux 2.6.26-2-vserver-amd64 #1 SMP Sun Jun 20 20:40:33
UTC 2010 x86_64 GNU/Linux
(tests ar
Greg,
First : thank you for you help.
On 22/07/2010 15:32, Greg Smith wrote:
Philippe Rimbault wrote:
I have one thousand inherited tables like this one (with a different
check constraint on each) :
The PostgreSQL partitioning system is aimed to support perhaps a
hundred inherited tables
8.27 rows=1 width=8) (actual time=0.005..0.006 rows=1 loops=1)"
"Index Cond: (id = 113)"
"Total runtime: 0.095 ms"
Results are better than 8.4 if query is on inherted table but worth if
query is on primary table.
So waiting for 9.0 will
Oups! searching on the mailing list show me that it's a known problem ...
http://archives.postgresql.org/pgsql-performance/2010-07/msg00063.php
sorry !
On 22/07/2010 09:52, Philippe Rimbault wrote:
Hi all,
I'm using Postgresql 8.4.4 on Debian.
In postgresql.conf, constraint_ex
Hi all,
I'm using Postgresql 8.4.4 on Debian.
In postgresql.conf, constraint_exclusion is set to "on"
I have partitioned tables with check constraints.
My primary table :
CREATE TABLE documents
(
id serial NOT NULL,
id_source smallint,
nod integer,
num te
