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_
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
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
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
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)
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
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
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
Hi,
Can anyone know how to define global variable in plpgsql?
Thanks
Regards,
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
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
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
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
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
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
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
16 matches
Mail list logo
