Stanislav Raskin wrote:
I figure there must be a better way to do so. Is there some kind of
software, which compares two database schemas (preferably two sql dumps),
and generates a script for applying differences to one of them?
What would be the best practice for applying such updates witho
> Is there a way do discover when was the last time a table or database
> vacuumed?
No, but you might look at the contrib pgstattuple function. The function
will give detailed information on the state of the table on disk.
michael
---(end of broadcast)--
On Fri, 3 Feb 2006, Nicolay A Vasiliev wrote:
> Hello there!
>
> http://news.zdnet.co.uk/software/0,39020381,39249666,00.htm
>
> What do you think about this?
>
> Nicolay
>
>
> ---(end of broadcast)---
> TIP 6: explain analyze is your friend
>
> > Why is there so much free space with no dead tuples? This table has
> > likely had serveral columns added over time, is that part of the problem?
> > Indexes?
>
> An ordinary vacuum frees space for PostgreSQL's use but it doesn't
> shrink the table's file(s) and return space to the operating
Hi,
I have an aging 7.3 database on Solaris 9/Sparc. We are on the verge of
upgrading Postgresql, but we first need to reclaim some disk space. I was
looking for tables that may have become fragmented when I saw this
pgstattuple output that confused me:
table_len 21773516800
tu
> I once read in an O'Reilly book on tuning Solaris about RAID-50. That's
> right multiple RAID-5 disk sets each treated as a single logical drive then
> striped with RAID-0. The book said that if built correctly load balancing
> could make performance approach RAID-10 at considerably lower cost
t might be happening here?
>
> Alex Turner
>
> ---(end of broadcast)---
> TIP 3: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faq
--
Conducive Technology Corporation
Taking air cargo information
to the n
