Hi Ramesh,
Are you able to provide a table schema? Were you using MyISAM or InnoDB
on MySQL?
If you back up the database & restore clean, what is the size comparison
of the database filed on the restored copy to the existing one? It may
be full of empty tuples. Is there any period where y
Hi Jeff,
Thanks for the detailed reply.
On 13/08/12 05:23, Jeff Janes wrote:
On Fri, Jul 27, 2012 at 9:33 PM, David Barton wrote:
Hi,
I have roughly 150 different databases, each of which is running in 1 of
roughly 30 tablespaces. The databases are small (the dump of most is are
under
Hi Yiannis,
Is there anything linking these ids together, or are the relatively
random? If they are relatively random, the rows are likely to be
sprinkled amongst many blocks and so a seq scan is the fastest. I've
seen similar problems with indexed queries in a multi-tennant database
where t
ehule wrote:
Hello
I had same problem with large numbers of tables - you can move
pg_stat_tmp to tmpfs filesystem - it was solution for us
Regards
Pavel
2012/7/28 David Barton :
Hi,
--
David Barton - Man
type of bounty
system where people can contribute to developing features?
Regards, David
On 29/07/12 00:13, Tom Lane wrote:
David Barton writes:
I am running postgres 9.1.4 on Ubuntu 12.04 and the stats collector is
generating very high IO usage even when nothing appears to be happening
on the
help would be sincerely appreciated.
David Barton d...@oneit.com.au
