[GENERAL] View table relationship

Hi. I have a big problem with postgres because I need to know how I can see the relations among the table like foreign-key. It' s possible use some commands or graphic tool from wich I can see that relations? Do you know some sites where i can found more information about this! Thank you very muc

[GENERAL] questions about how to implement a gist index

GIST_LEAF macro or the leafkey attribute of the GISTENTRY data structure? Thank you very much in advance, Riccardo

Re: [GENERAL] questions about how to implement a gist index

Hi Oleg, On Tue, Jun 28, 2016 at 1:05 AM, Oleg Bartunov wrote: > On Tue, Jun 28, 2016 at 12:44 AM, Riccardo Vianello > wrote: > > Could you please also help me understand the difference (if any) between > > using the GIST_LEAF macro or the leafkey attribute of the GISTENTRY

[GENERAL] SCSI disk: still the way to go?

recently changed? Any other suggestion/advice? What about SAN?   Thanks.Cheers,Riccardo

Re: [GENERAL] SCSI disk: still the way to go?

Hi Alex,   thanks for the answer (thanks to the other guys too!). http://www.cdw.com/shop/products/default.aspx?EDC=912784 SATA - ~$320 Is there a particular reason why you chose a SATA-150 drive? What about SATA-300?Cheers,Riccardo

Re: [GENERAL] [PERFORM] pg_restore taking 4 hours!

--- Shridhar Daithankar <__> wrote: > On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote: > > I need to find a solution for this because I am convincing > customers > > that are using SQL Server, DB2 and Oracle to change to PostgreSQL > but > > this customers have databases of 5GB!!! I am

Re: [GENERAL] Scheduler in Postgres

--- Bruno Wolff III <__> wrote: > On Thu, Dec 16, 2004 at 10:47:46 +0100, > Csaba Nagy <[EMAIL PROTECTED]> wrote: > > The only advantage would be that an in-database solution would be > OS > > independent and it could be managed using the same tools which > manage > > the database itself, inclu

Re: [GENERAL] Scheduler in Postgres

--(end of > broadcast)--- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match > Best, Riccardo ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Check if table exists

--- "ON.KG" <__> wrote: > Hi ALL! > > I need to check before selection records from table - does this table > exist > How can i do that? > > Thanx in advance > > > ---(end of > broadcast)--- > TIP 1: subscribe and unsubscribe commands go to > [E

Re: [GENERAL] Check if table exists

Sorry: I forgot to add something to option 2 --- "ON.KG" <__> wrote: > Hi ALL! > > I need to check before selection records from table - does this table > exist > How can i do that? > > Thanx in advance > > > ---(end of > broadcast)--- > TIP 1: