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)
Thi
2011/6/2 Teodor Sigaev
> 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 is split
2011/6/1 Alexander Korotkov
> 2011/6/1 Teodor Sigaev
>>
>> 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
> distribution algorithms. In quadrat
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_size('cubtest'));
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_
size('cubtest'))
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 wrote:
> On Sun, May 22, 2011 at 6:42 AM, Nick Raj wrote:
> > I am using contrib/cube code. I am building GIST index on cube
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
On Mon, May 16, 2011 at 7:52 PM, Tom Lane wrote:
> Robert Haas writes:
> > On Mon, May 16, 2011 at 3:41 AM, Nick Raj wrote:
> >> "How to get arguments toastable??" and even my table
> pg_class.reltoastrelid
> >> entry is zero.
>
> > It's
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 foun
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 wrote:
> Em 06-05-2011 02:14, Nick Raj escreveu:
>
&g
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
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 *ts=(ch
Hi,
Can anyone know how to define global variable in plpgsql?
Thanks
Regards,
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
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 thi
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
16 matches
Mail list logo
