Re: [PERFORM] [GENERAL] Ubuntu question

Q Master wrote: Hello, I had postgresql 7.4 on ubuntu and over one year ago I moved to 8.2 Till now I was backing up my db via pgadmin remotely from windows but now I want to do it from the ubuntu server. When I run the command pgdump it said that the database is 8.2 but the tool is 7.4 -

Re: [PERFORM] [GENERAL] Ubuntu question

sorry all i accident cross posted fat fingered it Justin wrote: Q Master wrote: Hello, I had postgresql 7.4 on ubuntu and over one year ago I moved to 8.2 Till now I was backing up my db via pgadmin remotely from windows but now I want to do it from the ubuntu server. When I run the

[PERFORM] Creating a foreign key

PostgreSQL: 8.2 When you create a foreign key to a table is there an index that is created on the foreign key automatically? Example: Table A has a field called ID. Table B has a field called fk_a_id which has a constraint of being a foreign key to table A to field ID. Is there an

Re: [PERFORM] Creating a foreign key

On Thu, 8 May 2008 11:52:50 -0500 Campbell, Lance [EMAIL PROTECTED] wrote: PostgreSQL: 8.2 When you create a foreign key to a table is there an index that is created on the foreign key automatically? No. Joshua D. Drake -- The PostgreSQL Company since 1997:

Re: [PERFORM] Creating a foreign key

On Thu, 2008-05-08 at 17:52 +0100, Campbell, Lance wrote: Is there an index automatically created on field fk_a_id in table B when I create a foreign key constraint? No. The problem with doing this is it assumes certain things about your infrastructure that may be entirely false. Indexes

Re: [PERFORM] Creating a foreign key

Shaun, Thanks for the very detailed description of why posgres does not auto create indexes. That makes a lot of sense. Thanks again, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu -Original

[PERFORM] Creating indexes

Hi, all. I want to ask what type of index is better to create for bigint types. I have table with bigint (bigserial) primary key. What type is better to use for it? I tried btree and hash, but didn't notice any differences in execution time. For GiST and GIN there is a trouble that I must create

Re: [PERFORM] Creating indexes

Hi, all. I want to ask what type of index is better to create for bigint types. I have table with bigint (bigserial) primary key. What type is better to use for it? I tried btree and hash, but didn't notice any differences in execution time. For GiST and GIN there is a trouble that I must create