Re: [GENERAL] plan-reading extensive tutorial?

2004-04-19 Thread Chris
On Mon, 2004-04-19 at 08:35, Klint Gore wrote: > In the docs it says "Plan-reading is an art that deserves an extensive > tutorial, which this is not". Is there one? I've gone beyond simple > queries (which are performing well) to the more difficult queries (which > aren't). Red Hat has a tool

Re: [GENERAL] plan-reading extensive tutorial?

2004-04-19 Thread Shridhar Daithankar
Klint Gore wrote: In the docs it says "Plan-reading is an art that deserves an extensive tutorial, which this is not". Is there one? I've gone beyond simple queries (which are performing well) to the more difficult queries (which aren't). Try this one.. http://www.gtsm.com/oscon2003/toc.html

[GENERAL] doubt about pg_dumpall

2004-04-19 Thread javier garcia - CEBAS
Hi all; In the documentation I'm missing some explanation about pg_dumpall. I would like to know if there is any difference if I restore an entire database cluster over an existing database or over an empty cluster. For example: if I restore the database cluster over a database that contains mo

[GENERAL] Storing images in a field

2004-04-19 Thread Együd Csaba
Hi All, I use PG 7.3.2 an 7.4.1 on RH 7.1. I'd like to store small (~ 100x100 px jpeg, or gif) images in a field in binary format. I tried to understand the documentation of the large objects but I'm afraid I coluldn't. I found some functions to import and export binary files into the db, but these

Re: [GENERAL] Cursors and PHP

2004-04-19 Thread scott.marlowe
I'm not sure why you're doing it the exact way you are, but you basically just call the same commands within a pg_query as you would on the psql command line to make it work: begin declare mycurs cursor as select * from table fetch 10 rollback / commit ---(end of bro

Re: [GENERAL] Storing images in a field

2004-04-19 Thread Richard Huxton
On Monday 19 April 2004 16:28, Együd Csaba wrote: > Hi All, > I use PG 7.3.2 an 7.4.1 on RH 7.1. > I'd like to store small (~ 100x100 px jpeg, or gif) images in a field in > binary format. > How can I insert a block of binary data into a given field form the client > (WinXP, pgsqlODBC 7.03.01)? An

[GENERAL] Postgresql 7.4.1 - Template database and user permission

2004-04-19 Thread Froggy / Froggy Corp.
Hello, I'am using postgresql to make different web site with differente database for each, but with same table/link/... So, i change from 7.2 to 7.4 and try to use template function to create each new DB more easier (with user posgres): CREATE DATABASE myowntemplate TEMPLA

[GENERAL] Running Multiple Postmasters

2004-04-19 Thread Clay Luther
Title: Message I am wondering if it is possible, or even advisable, to run two postmasters on a single system.   For example, we have an embedded system with a normal runtime partition (called the "A") in which the PGDATA is /var/lib/pgsql/data. We also have a offline partition which is a c

[GENERAL] Using of GeQo

2004-04-19 Thread Froggy / Froggy Corp.
Hello (again), I read some documentation about tuning postgresql.conf but i didn't find information clearly about how to use GeQo. It seems to help planner but using a lot of CPU, and is usefull only for big join. Per default, geqo = true, but in which case, geqo is usefull and in

Re: [GENERAL] Storing images in a field

2004-04-19 Thread Andrew Ayers
Együd Csaba wrote: > Hi All, > I use PG 7.3.2 an 7.4.1 on RH 7.1. > I'd like to store small (~ 100x100 px jpeg, or gif) images in a field in > binary format. > I tried to understand the documentation of the large objects but I'm afraid > I coluldn't. > I found some functions to import and export bi