hello,
i've got a table that looks like this (irrelevant data removed);
create table test (
id serial primary key,
t_end timestamp);
there's an index:
create index test_t_end on test(t_end);
can or should a query like:
select login,t_end from test order by t_end desc;
use the index? e
On Saturday 06 December 2003 20:50, Bruce Momjian wrote:
> Postgres-R is not ready for production, and development seems to have
> stopped., and I don't know what multi-master solutions we can really
> offer right now. We do have several master/slave replication solutions.
thanks. i'll look at t
On Fri, Mar 26, 2010 at 1:02 AM, Allan Kamau wrote:
> A classic problem. I would like to assign integer values (from a
> sequence) to records in a table based on the order (of contents) of
> other field(s) in the same table.
Do you have a simple example? (create table, insert some data, then sho
hello all,
i've got a database that takes up 4G of space. when i run a script that
deletes all rows and then vacuum, the data directory gets down to
around 3-3.5G. what i'd like is to get a blank database structure that
really contains no data at all, or any unused space at all. apparently
tha
