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
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
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
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
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
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
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
