Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
OK, this is what I'm trying (7.3.4):
create index blah on forums_posts using gist(ftiidx, datetime);
ERROR: data type timestamp with time zone has no default
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
OK, this is what I'm trying (7.3.4):
create index blah on forums_posts using gist(ftiidx, datetime);
ERROR: data type timestamp with time zone has no default operator class
for access method gist
That's got nothing to do with it being a
why there are no operators +-*/ to oid data type ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ivan [EMAIL PROTECTED] writes:
why there are no operators +-*/ to oid data type ?
Why should there be? Addition on OIDs seems like a meaningless
operation, at least for the intended usage of OIDs (namely as
opaque identifiers).
Yes, I know we have and = and similar operators on OID, but those
On Mon, 5 Jan 2004, Christopher Kings-Lynne wrote:
Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
you need to install contrib/btree_gist
btw, tsearch2 is much better than tsearch.
Check
On Mon, 5 Jan 2004, Christopher Kings-Lynne wrote:
Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
OK, this is what I'm trying (7.3.4):
create index blah on forums_posts using gist(ftiidx, datetime);
On Fri, Jan 02, 2004 at 12:21:22PM -0500, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
Tom Lane wrote:
Another little problem is that plpgsql doesn't really have any mechanism
for invalidating cached stuff at all; it will leak memory like there's
no tomorrow if we start dropping
On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
ok, bat each time where i want to do select .. a nie tu use to_char,
but it should be in function timestamp_out to convert time to string
it would be easer and faster.
I don't think it will too much faster :-)
BTW, for example the
I see following in the doc:
Table 9-21. Template Patterns for Date/Time Formatting
:
:
J Julian Day (days since January 1, 4712 BC)
I think 4712 should be 4713.
--
Tatsuo Ishii
---(end of broadcast)---
TIP 8: explain analyze is your friend
when i see the source codes in the bin directory,i find some very interesting codes:cat EOF\. INSERT INTO pg_description SELECT \t.objoid, c.oid, t.objsubid, t.description \ FROM tmp_pg_description t, pg_class c WHERE c.relname = t.classname;EOF) \| "$PGPATH"/postgres $PGSQL_OPT template1
Adam Witney [EMAIL PROTECTED] writes:
I have one regression failure on 7.4.1, which does not occur with 7.4
[EMAIL PROTECTED] more src/test/regress/regression.diffs
*** ./expected/random.out Thu Feb 13 05:24:04 2003
--- ./results/random.outTue Dec 23 20:19:40 2003
Is it possible to make a composite GiST index? I want to create an
index on a txtidx and a timestamp column - is that at all possible?
OK, this is what I'm trying (7.3.4):
create index blah on forums_posts using gist(ftiidx, datetime);
ERROR: data type timestamp with time zone has no
On Sun, Jan 04, 2004 at 07:59:02PM -0600, D. Dante Lorenso wrote:
Anything other than simple, short commands is a waste, IMHO. I can easily
remember SHOW DATABASES and SHOW TABLES and DESC table, because they
reflect
my intensions directly and 'make sense'.
What makes sense to me in csh
Josh Berkus [EMAIL PROTECTED] writes:
2) DEVELOP BETTER PLANS FOR OR GROUP QUERIES
Summary: Currently, queries with complex or group criteria get devolved by
the planner into canonical and-or filters resulting in very poor execution on
large data sets. We should find better ways of dealing
On Jan 2, 2004, at 4:54 PM, Alvaro Herrera wrote:
I think your approach is too ugly. You will have tons of problems the
minute you start thinking about concurrency (unless you want to allow
only a single user accessing the index)
It might be ugly, but it's very fast. Surprisingly fast, actually.
On 5 Jan, Tom Lane wrote:
Josh Berkus [EMAIL PROTECTED] writes:
2) DEVELOP BETTER PLANS FOR OR GROUP QUERIES
Summary: Currently, queries with complex or group criteria get devolved by
the planner into canonical and-or filters resulting in very poor execution on
large data sets. We
UNSUBSCRIBE
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Andrew Dunstan wrote:
Will we need to address this TODO item:
. Add capability to create and call PROCEDURES
before proceding to do PL/Java? It would add to the usefulness
greatly, I should think. I'm not sure how hard it would be.
This should be relatively easy if you omit OUT
Jean-Eric Cuendet wrote:
- User permissions based on columns? (Ex: User1 has Select on Column
CompayName but User2 has update on column CompanyName while User3
has create new row on table).
Well, I have about half a patch for column privileges lying around, but
I've never had enough
Title: Message
I have been working
with Postgres for just a short while, however, we are looking to use Postgres
for our next project and I was hoping someone could answer a question for me
regarding the planner to save me some research time.
How integrated is
the planner into the
Keith Bottner wrote:
How integrated is the planner into the database? Put another way, how
hard would it be to separate the planner from the core database in
such a way that it could be easily replaced either during compilation
or even better with a runtime setting?
The planner is
2 things.
I submitted a patch for this 5 months ago, which is still waiting to be
merged (hope it hasn't bitrotted in the meantime):
. Allow log lines to include session-level information, like database
and user
If nobody is working on this I am prepared to look at it:
. Allow logging of
Peter Eisentraut wrote:
Keith Bottner wrote:
How integrated is the planner into the database? Put another way, how
hard would it be to separate the planner from the core database in
such a way that it could be easily replaced either during compilation
or even better with a runtime setting?
there can be same problems with back convering, but its would be only
when select is going out, to cstring form, and all its depend on user,
but this is ok :)
On Mon, 5 Jan 2004, Karel Zak wrote:
On Sat, Jan 03, 2004 at 10:20:57PM +0100, ivan wrote:
ok, bat each time where i want to do
On Mon, 2004-01-05 at 10:02, Tatsuo Ishii wrote:
I see following in the doc:
Table 9-21. Template Patterns for Date/Time Formatting
:
:
J Julian Day (days since January 1, 4712 BC)
I think 4712 should be 4713.
template1=# select to_char('1 Jan 4713BC'::date,'J');
to_char
-
38
Peter Eisentraut wrote:
Andrew Dunstan wrote:
Will we need to address this TODO item:
. Add capability to create and call PROCEDURES
before proceding to do PL/Java? It would add to the usefulness
greatly, I should think. I'm not sure how hard it would be.
This should be relatively easy
I wrote:
If nobody is working on this I am prepared to look at it:
. Allow logging of only data definition(DDL), or DDL and modification
statements
Here are some options:
1. change the type of log_statement option from boolean to string,
with allowed values of all, mod, ddl, none with
UNSUBSCRIBE
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
Hi there,
I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but more languages could be added. We plan to add searchable
connection failed :(
Dave
On Mon, 2004-01-05 at 09:49, Oleg Bartunov wrote:
Hi there,
I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface
connection failed :(
Dave
I had no problem accessing it - very nice and responsive ! Great job Oleg
and Teodor.
-- Glenn
- Original Message -
From: Dave Cramer [EMAIL PROTECTED]
To: Oleg Bartunov [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; Pgsql Hackers
[EMAIL PROTECTED]
Sent:
On Mon, 2004-01-05 at 14:49, Oleg Bartunov wrote:
Hi there,
I'm pleased to present pilot version of http://www.pgsql.ru - search system on
postgresql related resources. Currently, we have crawled 27 sites,
new resources are welcome. It has multi-languages interface (russian, english)
but
Alex J. Avriette wrote:
On Sun, Jan 04, 2004 at 07:59:02PM -0600, D. Dante Lorenso wrote:
Anything other than simple, short commands is a waste, IMHO. I can easily
remember SHOW DATABASES and SHOW TABLES and DESC table, because they
reflect
my intensions directly and 'make sense'.
Andrew Dunstan wrote:
2 things.
I submitted a patch for this 5 months ago, which is still waiting to be
merged (hope it hasn't bitrotted in the meantime):
. Allow log lines to include session-level information, like database
and user
If nobody is working on this I am prepared to
34 matches
Mail list logo