[HACKERS] Different execution time for same plan

2011-06-06 Thread Nick Raj
Hi, I am using postgresql 8.4.6. I have made an index on my data-type that is working fine. I mean output is coming properly. When i execute the query first time, query takes a quite longer time but second time execution of the same query takes very less time (despite execution plan is same)

Re: [HACKERS] Cube Index Size

2011-06-04 Thread Nick Raj
2011/6/2 Teodor Sigaev teo...@sigaev.ru Can we figure out some information about index i.e. whet is the height of index tree, how many values are placed in one leaf node and one non leaf level node? http://www.sigaev.ru/cvsweb/cvsweb.cgi/gevel/ For improving space utilization, When node

Re: [HACKERS] Cube Index Size

2011-06-01 Thread Nick Raj
2011/6/1 Alexander Korotkov aekorot...@gmail.com 2011/6/1 Teodor Sigaev teo...@sigaev.ru One of idea is add sorting of Datums to be splitted by cost of insertion. It's implemented in intarray/tsearch GiST indexes. Yes, it's a good compromise between linear and quadratic entries

[HACKERS] Cube Index Size

2011-05-30 Thread Nick Raj
Hi, Cube code provided by postgres contrib folder. It uses the NDBOX structure. On creating index, it's size increase at a high rate. On inserting some tuple and creating indexes its behaviour is shown below. 1. When there is only one tuple select pg_size_pretty(pg_relation_

[HACKERS] Cube Index Size

2011-05-30 Thread Nick Raj
Hi, Cube code provided by postgres contrib folder. It uses the NDBOX structure. On creating index, it's size increase at a high rate. On inserting some tuple and creating indexes its behaviour is shown below. 1. When there is only one tuple select

[HACKERS] Logfile

2011-05-22 Thread Nick Raj
Hi, I am using contrib/cube code. I am building GIST index on cube data type then it leads to a very large size of log file (nearly 220 MB for only 12k records). While creating index on geometry field with gist gives 1KB size of log file for 17 lakh records. Can someone please tell me how to stop

Re: [HACKERS] Logfile

2011-05-22 Thread Nick Raj
sorry, actually becuase of one printf statement(i have added) because of that, these has been occured. My mistake On Mon, May 23, 2011 at 9:06 AM, Robert Haas robertmh...@gmail.com wrote: On Sun, May 22, 2011 at 6:42 AM, Nick Raj nickrajj...@gmail.com wrote: I am using contrib/cube code. I am

[HACKERS] DETOAST Datum

2011-05-16 Thread Nick Raj
Hi, I have defined some function and also used NDBOX structure that having variable length. typedef struct NDBOX { int32vl_len_;/* varlena length */ unsigned int dim; doublex[1]; } NDBOX; When i called my function, it gives NDBOX to be null On debugging, i

Re: [HACKERS] DETOAST Datum

2011-05-16 Thread Nick Raj
On Mon, May 16, 2011 at 7:52 PM, Tom Lane t...@sss.pgh.pa.us wrote: Robert Haas robertmh...@gmail.com writes: On Mon, May 16, 2011 at 3:41 AM, Nick Raj nickrajj...@gmail.com wrote: How to get arguments toastable?? and even my table pg_class.reltoastrelid entry is zero. It's pretty hard

Re: [HACKERS] Debug contrib/cube code

2011-05-13 Thread Nick Raj
Sorry i don't know about AFAICS. Yes, i want to modify cube code for this i want to go in detail by debugging. Can you throw some light on how to debug contrib/cube code? On Fri, May 6, 2011 at 9:59 PM, Euler Taveira de Oliveira eu...@timbira.com wrote: Em 06-05-2011 02:14, Nick Raj escreveu

[HACKERS] Debug contrib/cube code

2011-05-05 Thread Nick Raj
Hi, I am using postgresql-8.4.6. I want to debug the contrib/cube code. Can we able to debug that cube code? Because there is no .configure file to enable debug. Is there is any way to change make file to enable debug? Thanks

[HACKERS] Defining input function for new datatype

2011-04-21 Thread Nick Raj
Hi, I am defining a new data type called mpoint i.e. typedef struct mpoint { Point p; Timestamp t; } mpoint; For defining input/output function 1 Datum mpoint_in(PG_FUNCTION_ARGS) 2 { 3 4mpoint *result; 5char *pnt=(char *)malloc (sizeof (20)); 6char

[HACKERS] Global variables in plpgsql

2011-04-11 Thread Nick Raj
Hi, Can anyone know how to define global variable in plpgsql? Thanks Regards, Raj

Re: [HACKERS] Composite Index Structure

2011-03-07 Thread Nick Raj
Raj On Mon, Mar 7, 2011 at 12:33 PM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 07.03.2011 08:07, Nick Raj wrote: I want to construct an Composite Index Structure i.e. a combination of gist and btree. What i am thinking is that first creating a Rtree structure

[HACKERS] Composite Index Structure

2011-03-06 Thread Nick Raj
Hi all, I want to construct an Composite Index Structure i.e. a combination of gist and btree. What i am thinking is that first creating a Rtree structure that is pointing to another Btree structure. For example, Suppose i want to find vehicles between 2 to 4 pm on 14/2/2011 on X road. I am

[HACKERS] Spatio-Temporal Functions

2011-02-26 Thread Nick Raj
Hi, I am writing some spatio-temporal function in postgis. Like, ST_Enters( obj_geom, boundary_geom, time t1,time t2) For example- Does vehicle enters in ABC between time t1 to t2? Let us suppose, i take only one object geometry at a time and do compare then i could not produce the output because