waldomiro wrote:
> I need to know how much the postgres is going to disk to get
> blocks and how much it is going to cache? witch is the
> statistic table and what is the field that indicates blocks
> reads from the disk and the memory cache?
The view pg_statio_all_tables will show you the numb
On Thu, Oct 15, 2009 at 9:33 PM, waldomiro wrote:
> Helo everbody!
>
> I need to know how much the postgres is going to disk to get blocks and how
> much it is going to cache? witch is the statistic table and what is the field
> that indicates blocks reads from the disk and the memory cache?
Ye
Helo everbody!
I need to know how much the postgres is going to disk to get blocks and how
much it is going to cache? witch is the statistic table and what is the field
that indicates blocks reads from the disk and the memory cache?
Another question is, what is the best memory configuration to
This appears to be a bug in the optimizer with resepct to planning
queries involving child partitions. It is clear that "any" index is
being ignored even if the selectivity is high. I had to re-write the
same query by explicitly "union-all" ' ing the queries for individual
partitions.
On Wed, Oct
Hi ,
In my project I use Nhibernate to connect to Postgres.
Currently it is very slow.
I have used *Yourkit* profiller to get some key informaitons.
In CPU profilling i have analyzed following things : -
Let me explain one by one : -
1- NHibernate.Impl.SessionImpl.DoLoad(Type, Object, Object, L
Hi chaps,
Can anyone recommend a decent server vendor in the UK?
I'm looking to deploy a new machine to handle some of our non-critical data,
and I'm just wondering if I can avoid the pains I've had with dell hardware
recently.
Also whilst I'm asking, does anyone else find their dell BMC/DRAC
