[ADMIN] VACUUM problems

hello, All ! I'm freshman to this list. Before version 7.1 there was restriction on SQL tuple length 8-32Kb. Now I'm using 7.1.2 where iz no such limitations. I have created some documents database. Theare is table with full text of documents. Some rows are up to 400Kb lenght. The database is

Re: [ADMIN] moving database to production

On 28 Sep 2001, at 12:12, Srinivasa Rao Chava wrote: > Hi, > How to move the database from devleopment to production. > For example, the database is already in production and some of the > tables required modifications. First those modification were > implemented in develoment. The modified table

[ADMIN] indexes

Hi All! Is REINDEX TABLE xxx; the same as DROP INDEX ... ; CREATE INDEX ... on xxx (..); or there are differences? Mark ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[ADMIN] Performance

Hello all! I need to setup high performance DB server. Some time ago I red there about processor cache influence on query execution performance. A question: What system would perform better? lh6000 with two xeon 7000Mhz 2MB cache or with four xeon 7000Mhz 1MB cache Mark -

Re: [ADMIN] Performance

On 18 Jan 2002, at 9:22, Jeremy Buchmann wrote: > > It's more than just processor cache, it's your whole I/O subsystem. > How fast are your drives? How fast is the drive controller? How much > cache is on each drive? How much cache is on the drive controller? > Are you going to use a RAID? If

[ADMIN] tags in HTML formated output

Hi, All! Is there (in psql) any way to output link and formating tags in \H output mode? When I did select ''||id||'' from ... I got < and > in place of < and > Mark ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unre

[ADMIN] timestamp function in 7.2

Hello all. I'v migrated my data to 7.2. Now I'm testing aplications, but looks like timestamp function in postgres is broken: klienti=# select date(now()); date 2002-03-27 (1 row) klienti=# select timestamp(date(now())); ERROR: parser: parse error at or near "date" I need t

[ADMIN] FATAL 2: open of /usr/local/pgsql/data/pg_clog/0943 failed

I have this error in postgres log FATAL 2: open of /usr/local/pgsql/data/pg_clog/0943 failed: No such file or directory When it happend i did indexing on big table (~32M rows) On small selects, inserts, updates all seems to work fine, but when I try to do select count(*) from big table or intex

[ADMIN] ERROR: dtoi4: integer out of range

Hello all. heare is my problem. vestnesis=# select max(oid) from doc; max 2299015900 (1 row) vestnesis=# select id from doc where oid=2299015900; ERROR: dtoi4: integer out of range Postgres version 7.2.3. INSERT works fine version 7.2.4 also have this bug. I didn'

[ADMIN] ALTER TABLE

Hello! Can someone explain me, why last ALTER fails? work=# \d rdu Table "rdu" Column|Type | Modifiers -+-+-

[ADMIN] upgrade

Hekko, All! I'm planing to upgrade from 7.2.1 to 7.3.4. Will pg_dumpall and pg_restore be sufficient for propper data migration? Mark ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]