On Thu, 28 Oct 2004, Andrei Bintintan wrote:
> I try to dump a database from a 7.4.2 postgre system and to import it on
> a 7.3.2. system, but I have a problem with the sequences in the dump.
In general, the above is not guaranteed to work. pg_dump will use features
of the dumping version so mov
I am trying to replicate the DB
using pg_dump and pg_restore.When I use pg_restore it is appending the data to existing
data.This is not what I wanted.Even I used the flag -c .Can anybody throw
light on this.
> Hello,
>
> I'm running a search query on a table with
> approximately 120.000 rows
> (3848 relpages, dbsize tablesize 30MB).
>
> Because of poor performance I would like to cache
> the complete table in memory, but I'm not sure which
> config param I have
> to use to accomplish
> that.
> The o
Hi to all,
I try to dump a database from a 7.4.2 postgre
system and to import it on a 7.3.2. system, but I have a problem with the
sequences in the dump.
This is a seq example:
CREATE SEQUENCE test_id_seq
INCREMENT BY 1 NO MAXVALUE NO
MINVALUE CACHE 1;
This gives me an
Hi.
There was an idea to make access to the data only through the built - in
functions (on C). There is a table 't_test' which the superuser can read and
write down. There are functions of access, for example, for an insert of the
data:
PG_FUNCTION_INFO_V1(f_test);
Datum
f_test(PG_FUNCTION_ARG
Title: RE: [ADMIN] caching complete table for optimizing search ?
I'm not sure what to do to cache a single table, but we use a tool called memcached to accomplish what you are describing. Memcached will cache the db in RAM, allowing you to do all of your reads from memory. Writes are more e
Hello,
I'm running a search query on a table with approximately 120.000 rows
(3848 relpages, dbsize tablesize 30MB).
Because of poor performance I would like to cache the complete table in
memory, but I'm not sure which config param I have to use to accomplish
that.
The other tables in the db are
Hi Jagdish,
You shouldn't be listing each IP address in the file. If you want a
specific IP address then the netmask should have been 255.255.255.255 to
indicate that all octets are required for the address comparison.
For your subnet you should have an IP subnet of 192.168.0.0 and a
netmask o
