Re: [PERFORM] Saving result set of SELECT to table column

2008-01-14 Thread Robins Tharakan
Hi Patric, This doesn't seem to be a question pertaining to the PERFORM queue. If I understand you correctly, this should solve your problems, without the need for any RULES / TRIGGERS. CREATE TABLE y ( y1 int4 NOT NULL, y2 varchar, CONSTRAINT a PRIMARY KEY (y1) ) CREATE TABLE z ( z1 i

Re: [PERFORM] Seq scans on indexed columns.

2008-01-14 Thread Shane Ambler
Yannick Le Guédart wrote: Greetings, I was trying to get informations on #portgresql about a query plan I think is quite strange, and I was said to post on this list. I hope my mail will be clear enough. I have included the query, the query plan, and the table definitions. I just

Re: [PERFORM] Saving result set of SELECT to table column

2008-01-14 Thread Ansgar -59cobalt- Wiechers
On 2008-01-14 Patric wrote: > Well I've a normalized database.. > For instance: > > create table Y ( pk, data... ); > create table Z ( pk , data...); > > create table X ( char, references Y, references Z); > > SELECT * from X; > > Now I want to make a listing of the resul

[PERFORM] Saving result set of SELECT to table column

2008-01-14 Thread Patric
Hi, There will be some flames i suppose. Well I've a normalized database.. For instance: create table Y ( pk, data... ); create table Z ( pk , data...); create table X ( char, references Y, references Z); SELECT * from X; Now I want to make a listing of the result set

Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores

2008-01-14 Thread Tom Lane
Jakub Ouhrabka <[EMAIL PROTECTED]> writes: > What does it mean? Look at src/include/storage/sinval.h and src/include/utils/syscache.h. What you seem to have here is a bunch of tuple updates in pg_class (invalidating caches 29 and 30, which in 8.2 correspond to RELNAMENSP and RELOID), followed by a

Re: [PERFORM] Seq scans on indexed columns.

2008-01-14 Thread Guillaume Cottenceau
Yannick Le Guédart writes: > Greetings, > > I was trying to get informations on #portgresql about a query plan I > think is quite strange, and I was said to post on this list. I hope my > mail will be clear enough. I have included the query, the query plan, > and the table definitions

[PERFORM] Seq scans on indexed columns.

2008-01-14 Thread Yannick Le Guédart
Greetings, I was trying to get informations on #portgresql about a query plan I think is quite strange, and I was said to post on this list. I hope my mail will be clear enough. I have included the query, the query plan, and the table definitions. I just don't understand the "Seq

Re: [PERFORM] Best way to index IP data?

2008-01-14 Thread Michael Stone
On Mon, Jan 14, 2008 at 03:05:27PM +0100, Florian Weimer wrote: Hmm. It's an argument for a separate CIDR type, not against a host type. I don't think anyone argued against the CIDR type. :-) Mike Stone ---(end of broadcast)--- TIP 6: explain a

Re: [PERFORM] Best way to index IP data?

2008-01-14 Thread Florian Weimer
* Michael Stone: >>Classful addressing is still part of many user interfaces, for >>instance Cisco's IOS. It's not just that the CLI accepts it, it's >>also the standard[*] output format (that is, "192.0.2.0" instead of >>"192.0.2.0/24"; if no prefix length is given, the one based on the >>class

Re: [PERFORM] Linux/PostgreSQL scalability issue - problem with 8 cores

2008-01-14 Thread Jakub Ouhrabka
Hi Tom, > Strange. The best idea that comes to mind is to add some debugging > code to SendSharedInvalidMessage to log the content of each message > that's sent out. That would at least tell us *what* is going into > the queue, even if not directly *why*. we've patched postgresql and run one o

Re: [PERFORM] Best way to index IP data?

2008-01-14 Thread Michael Stone
On Mon, Jan 14, 2008 at 09:27:52AM +0100, Florian Weimer wrote: * Steve Atkins: I don't think there's ambiguity about what an dotted-quad without a netmask means, and hasn't been for a long time. Am I missing something? Classful addressing is still part of many user interfaces, for instance Ci

Re: [PERFORM] Best way to index IP data?

2008-01-14 Thread Florian Weimer
* Steve Atkins: > I don't think there's ambiguity about what an dotted-quad without a > netmask means, and hasn't been for a long time. Am I missing > something? Classful addressing is still part of many user interfaces, for instance Cisco's IOS. It's not just that the CLI accepts it, it's also