Re: [GENERAL] R: One column to multiple columns based on constraints?

2010-02-09 Thread BillR
Is there any reason it has to be done in one DML statement? Can you write a procedure to this in multiple steps? BillR From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Davor J. Sent: February-09-10 2:02 PM To: pgsql-general@postgresql.org

Re: [GENERAL] Best way to handle multi-billion row read-only table?

2010-02-09 Thread BillR
re what facility Postgres has for this though (I would be interested to hear comments on this too! :-) BillR -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Asher Sent: February-09-10 12:47 PM To: pgsql-general@postgre

Re: [GENERAL] Multiple buffer cache?

2010-02-06 Thread BillR
I don't know how to do this with PostgreSQL, but I am pretty sure what Alexei is looking for is what Oracle and SQL Server people refer to as 'pinning' a table or other DB object (into memory). I would be interested to know if PostgreSQL does this too. I think it is a very useful feature. How to