Simon Riggs a écrit :
On Mon, Jun 20, 2011 at 3:01 PM, adrien ducos wrote:
I have postgres 8.4
I have a table "foo" with 16 million lines 99% of those lines have a column
"bar" = 1.
I had an index on this table:
CREATE INDEX index_foo_bar ON foo using btree (bar);
T
o which uses prepared
statements all the time and is unable to use all the partial indexes.
The problem is I have 90 GB of indexes in the database and partial
indexes could help me to save some of this space on my server, in
addition to improve the speed of the queries.
Adrien DUCOS
for referenced table"
, so i will try to use pg_restore as you have mentioned below.
On Mon, May 9, 2011 at 12:19 PM, adrien ducos <mailto:adu...@hbs-research.com>> wrote:
It seams there is no option like that in pg_dump or pg_restore.
But You can manualy do it in the dump or
---
Wherever I go, Murphy goes with me
--
Logo_HBS_mail.jpg
Adrien DUCOS
Analyste développeur
adu...@hbs-research.com <mailto:adu...@hbs-research.com>
www.hbs-research.com <http://www.hbs-research.com/>
+33 (0)9 70 44 64 10
24 rue de l'Est
75020 Paris
--
Sent via pg
Kevin Grittner a écrit :
adrien ducos wrote:
Kevin Grittner a écrit :
What does this show?:
free -m
total used free shared buffers cached
Mem: 3042 3000 4104 2896
-/+ buffers/cache: 99 2942
Kevin Grittner a écrit :
adrien ducos wrote:
[rearranged somewhat]
The version of both databases is postgres 8.4.1
[sigh] You really should upgrade.
http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.4/static/release.html
I know I should but
2
0 95 3
The swap is not used but something is a bit odd: the cache is using 98%
of the RAM
if I do
SHOW shared_buffers;
I get
shared_buffers
512MB
as I would expect from my configuration.
I've got out of idea, any idea?
--
Logo_HBS_mail.jpg
Adrien DUCOS
A
