Skip site navigation (1) Skip section navigation (2)

Arrays vs separate system catalogs

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Arrays vs separate system catalogs
Date: 2002-02-27 17:13:22
Message-ID: Pine.LNX.4.30.0202271208070.688-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-hackers
During my coding of the per-user/database settings, it occurred to me one
more time that arrays are evil.  Basically, the initial idea was to have a
column pg_database.datconfig that contains, say,
'{"geqo_threshold=55","enable_seqscan=off"}'.  Just inserting and deleting
in arrays is terrible, let alone querying them in a reasonable manner.
We're getting killed by this every day in the privileges and groups case.

What are people's thoughts on where (variable-length) arrays are OK in
system catalogs, and where a new system catalog should be created?

-- 
Peter Eisentraut   peter_e(at)gmx(dot)net


Responses

pgsql-hackers by date

Next:From: Alex AvrietteDate: 2002-02-27 17:32:14
Subject: Re: Oracle vs PostgreSQL in real life
Previous:From: Doug McNaughtDate: 2002-02-27 17:12:27
Subject: Re: Oracle vs PostgreSQL in real life

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group