Re: [GENERAL] Large DB

2004-04-05 Thread Manfred Koizar
On Sat, 03 Apr 2004 22:39:31 -0800, "Mooney, Ryan" <[EMAIL PROTECTED]> wrote: >Ok, so I ran a vacuum analyse. It took ~1.7 days to finish. Just to make it clear: VACUUM and ANALYSE are two different commands. VACUUM is for cleaning up. It has to visit every tuple in every page, and if there

Re: [GENERAL] RPM init-script: Why the locale setting?

2004-04-05 Thread Tom Lane
Lamar Owen <[EMAIL PROTECTED]> writes: > ... The initdb locale > settings are stored in initdb.i18n, and they are re-sourced everytime > postgresql is started to prevent data corruption if postmaster is started > with a different locale from the initdb. Tom, is the data corruption issue > stil

Re: [GENERAL] RPM init-script: Why the locale setting?

2004-04-05 Thread Lamar Owen
On Sunday 04 April 2004 10:50 pm, Tom Lane wrote: > Troels Arvin <[EMAIL PROTECTED]> writes: > > In the init-script contained in the RPMs downloadable from the PostgreSQL > > site (I checked the one for Fedora), an explicit locale is set before > > running initdb. - And the explicit locale is not "

[SQL] Simple insert not returning

2004-04-05 Thread Kyle
PostgreSQL v7.4 on Solaris 9 I've got a simple table CREATE TABLE public.tbl_system ( system_id int4 NOT NULL DEFAULT nextval('public.id_seq'::text), system_name varchar(50) NOT NULL, description varchar(300), active bool DEFAULT true, CONSTRAINT pk_tbl_system PRIMARY KEY (system_id

Re: [GENERAL] Storing jpgs

2004-04-05 Thread scott.marlowe
On Mon, 5 Apr 2004, C G wrote: > Dear All, > > What's the best way to store jpgs in postgresql to use in a web page? > > I tried to use large objects, but how would you extract them from a table to > be viewed in a web-page without having to write them to a scratch file > somewhere first? The

Re: [GENERAL] Storing jpgs

2004-04-05 Thread Rod K
I've found bytea works better for me than large objects. As far as how to retrieve and display, that depends. What scripting language are you using? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of C G > Sent: Monday, April 05, 2004 12:20 PM > To: [EMA

Re: [GENERAL] thread_test.c problems

2004-04-05 Thread Greg Stark
Bruce Momjian <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] wrote: > > On 4/4/04 11:43 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > > > > OK, new patch applied that causes all threads to wait until the parent > > > checks their thread-specific pointers. I ran 1000 tests and all passed. >

Re: [GENERAL] Storing jpgs

2004-04-05 Thread Bob . Henkel
I won't say what is right or wrong to do. But some will say to store the file location in a field such as /mydocs/mypictures/myimage.jpg and then have your php or what ever open that file. by using a select statement. Not sure how you would store them in the database and pull it righ out. I w

Re: [GENERAL] thread_test.c problems

2004-04-05 Thread Bruce Momjian
Greg Stark wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > [EMAIL PROTECTED] wrote: > > > On 4/4/04 11:43 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > > > > > > OK, new patch applied that causes all threads to wait until the parent > > > > checks their thread-specific pointers. I r

[GENERAL] Storing jpgs

2004-04-05 Thread C G
Dear All, What's the best way to store jpgs in postgresql to use in a web page? I tried to use large objects, but how would you extract them from a table to be viewed in a web-page without having to write them to a scratch file somewhere first? Thanks Colin __

Re: [GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-05 Thread Cees van de Griend
Hello Miguel, On Monday 05 April 2004 15:58, Miguel Guzman Miranda wrote: > My issue is that I need to do some replication from Oracle tables to > PSQL. One-way only, incremental, and to a remote machine. I have to replicate a lot of data from Oracle/MS SQL/Progress to PostgreSQL I have wri

Re: [GENERAL] thread_test.c problems

2004-04-05 Thread wespvp
On 4/4/04 11:43 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > OK, new patch applied that causes all threads to wait until the parent > checks their thread-specific pointers. I ran 1000 tests and all passed. > Hopefully it will good for you too. I'll try to give it a test tonight. >> Dumb ques

[GENERAL] Mirroring tables from Oracle to Postgresql

2004-04-05 Thread Miguel Guzman Miranda
Hi there, First of all, I suppose my problem should be at least farly common, but haven't had luck trying to find what I need by searching on the docs, google, etc. So please if this issue has already been covered please point me to some URL, or the list archives, or what you think is fine

Re: [GENERAL] thread_test.c problems

2004-04-05 Thread Bruce Momjian
[EMAIL PROTECTED] wrote: > On 4/4/04 11:43 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote: > > > OK, new patch applied that causes all threads to wait until the parent > > checks their thread-specific pointers. I ran 1000 tests and all passed. > > Hopefully it will good for you too. > > I'll try t

[GENERAL] Evening in NYC

2004-04-05 Thread Bruce Momjian
SRA America is sponsoring an evening event with me in NYC. If folks want to go, the details are on our web site under "Events". -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Ro

[GENERAL] Optimize query

2004-04-05 Thread Michal Hlavac
Hello, I have one main table and 2 many-to-many relation tables and 2 one-to-many relation table. Main table has 150 000 rows and many-to-many tables have about 300 000 rows. I am creating web portal. In my query I must call distinct with many-to-many relation. But this query is too slow for web a

Re: [GENERAL] Problem restoring Database

2004-04-05 Thread mike
On Thu, 2004-04-01 at 20:08, Joshua D. Drake wrote: > mike wrote: > > I have just upgraded froom Fedora test1 to test2 which has upgraded > > postgres version from 7.4.2 to 7.4.5 (frrom rpm -q) > > Uhh unless I am missing something what you have done is impossible. > There is no 7.4.5 > > Are