Re: [GENERAL] pg_statio_all_indexes

Yes, you are right. I now tried to select from one table various amount of records and when the amount exceeded some given number so the blks_hit begun fall. Thanks, David Hoksza 30. července 2006, 20:24:33, napsal jste: TL> David Hoksza <[EMAIL PRO

[GENERAL] pg_statio_all_indexes

Hi, I'm not sure about the value idx_blks_hit of pg_statio_all_indexes view. Is it total value of touched pages, or do I get total value when I add idx_blks_read to it? In other words - does idx_blks_hit cover also physical reads? Thanks, David Hoksza ---(e

Re: [GENERAL] type of b-tree

OK, thanks. And I would like have one more question about B-tree index - how many records are usualy stored in one node (what's arity of the tree)? Thanks, David Hoksza 23. července 2006, 20:03:03, napsal jste: TL> David Hoksza <[EMAIL PROTECT

[GENERAL] type of b-tree

Hi, could anybody tell me which variation of B-tree PostgreSQL uses, that it can handle more than one column? Some link would be great. Thanks, David Hoksza ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] query execution time

This is not exactly what I'm searching for, but thanks.. David __ TL> David Hoksza <[EMAIL PROTECTED]> writes: >> Hi, is there a way how to get some more detailed times for query >> execution like Kernel Time, User Time and Process Time? TL> See lo

[GENERAL] query execution time

Hi, is there a way how to get some more detailed times for query execution like Kernel Time, User Time and Process Time? I would like see the time which PG really spends with computing without times from another processes (I'm running on Windows with PostgreSQL 8.1.3.). Thanks,

Re: [GENERAL] ambulkdelete

OK, thx... 27. března 2006, 14:51:26, napsal jste: JCN> On Sun, Mar 26, 2006 at 08:30:44PM +0200, David Hoksza wrote: >> Hi, I would like to know, when ambulkdelete is run. I thought that >> when tuple is deleted so bulkdelete is run, but when I

[GENERAL] ambulkdelete

Hi, I would like to know, when ambulkdelete is run. I thought that when tuple is deleted so bulkdelete is run, but when I set breakpoint to btbulkdelete, it doesn't stop there. Does it mean, that ambulkdelete is run just when I use VACUUM? David Hoksza ---(e

Re: [GENERAL] ambuild parameters

Yes, it came across my mind immediately atfter sending the mail yesterday , but didn't help:( (and it's dll - it's on win32). David Hoksza 22. března 2006, 4:26:07, napsal jste: TL> [EMAIL PROTECTED] writes: >> Probably the reason is, th

Re: [GENERAL] ambuild parameters

Info *indexInfo = (IndexInfo *) PG_GETARG_POINTER(2); Thanks, David Hoksza 20. března 2006, 23:20:12, napsal jste: TL> [EMAIL PROTECTED] writes: >> Thanks for answering, it was a good guess, I really didn't mark it, >> but unfortuna

[GENERAL] ambuild parameters

s the place, where it fails (the index_rel variable is not null). The same problem is, when I try to use heap_rel. I really can't find, where's the problem. I use almost the same code as btree or rtree does. Isn't the problem in the way I create the functions? I mean if the parameter type INTERNAL in: CREATE OR REPLACE FUNCTION atomrtbuild (INTERNAL ,INTERNAL, INTERNAL) RETURNS VOID AS 'E:\\pgsource\\postgresql-8.0.7\\contrib\\atomrtree\\libatomrtree.dll', 'atomrtbuild' LANGUAGE 'C'; is OK? I spent whole afternoon trying to change the params for OPAQUE aso., but nothing works:( Thanks, David Hoksza ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org