On Sat, Jan 08, 2005 at 18:45:17 -0800,
Jeff Davis <[EMAIL PROTECTED]> wrote:
> Is there a maximum size for posting to this list? I tried posting a
> somewhat involved question about PITR with the errors I got appended to
> the email, and it never arrived on the list.
Yes. What people are usual
I've looked into pshycho pg, it appears to be the best option, my later question
now remains, what documentation or examples would be useful in developing a
completely proprietary front end written in python. Any help finding useful
examples or documentation would be greatly appreciated.
thanks,
Ronnie Meier Ramos wrote:
Unfortunatly, faking them with some C functions would be very complex
because in this application's case most of this variables are record
types and some are arrays (pl/tables)... :-(
For record types, why not just use cursors? They can be made to persist
until the end
Is there a maximum size for posting to this list? I tried posting a
somewhat involved question about PITR with the errors I got appended to
the email, and it never arrived on the list.
I would still like to get my question answered, but it's hard to ask
without including at least the steps I went
(The example is really count(pkey) because count(*) is always going to
do a seq scan I reckon - and could probably never use an index).
postgres knows that count(*) is just "count the rows", you can use
count(1), it makes no difference...
Alex Turner
NetEconomist
On Fri, 07 Jan 2005 11:17:32 -
Never used ODBC with Python, but if you want to use Postgres, I'd
strongly recommend psycopg which I find the nicest and fastest postgres
adapter (certainly a lot better than Pygresql and pypgsql)
Regards
On Sat, 8 Jan 2005 18:01:01 -0600, <[EMAIL PROTECTED]> wrote:
We're looking in
I gather your program uses two steps, let's call them :
- parse( smiles ) -> data
- search( data ) -> result
You can create a functional index on your smiles column, but I don't know
if this will help you ; you can do things like CREATE INDEX ... ON
mytable( lower( myfi
We're looking into building a front end for our database in python.
The database in question is an educational database, that generates
new tables for each teacher, class and student. Was wondering if
anyone had any recommendations for similar projects to look at,
resources, and general informat
I've written a c-language extension to postgresql to implement a
chemical search of a varchar column (named smiles, typically).
It might be called as:
oe_matches(smiles,'COCC') where 'COCC' is a typical search string.
This uses 3rd party functions to parse the varchar inputs into c++
objects. I
I must not have been clear. In postgres you can limit people to a
tablespace (in 8.0 of course). You do this by giving them a database
with a default tablespace, and only give them permission on that default
tablespace. That works fine.
The problem is, there is no limit to the size of a tablespace
Alex Turner <[EMAIL PROTECTED]> writes:
> ... With the
> advent of Tablespace in pg 8.0, is it possible to set a user's default
> tablespace?
ALTER USER user1 SET default_tablespace = foo;
regards, tom lane
---(end of broadcast)
I know that this is off topic, but I'm not getting anywhere and wondered
if anyone has come across and solved this problem before.
We use Nagios to monitor our servers. Our Dell PE 1550s and 1750s are
monitored using a check_megaraid nagios plugin which uses SNMP and works
fine.
Our postgres d
hello to all
Soon time I am going to face a migration of a DBII
database our dear poststoneware. I will thank for any
advice that can give me, in addition this migration
will have 20 million records.
20 million record is to large instalation, exist some
tips for this type of facilities?
Tia .
Be
> No offense or anything, but that doesn't make any sense. If you are
> running count(*) against a table, it still has to worry about MVCC,
> and which rows are visible to your transaction. What difference does
> it make, table or index, the system still has to figure out which rows
> are visible
No offense or anything, but that doesn't make any sense. If you are
running count(*) against a table, it still has to worry about MVCC,
and which rows are visible to your transaction. What difference does
it make, table or index, the system still has to figure out which rows
are visible in the cu
Not sure what overhead - but Oracle has this ;) Infact Oracle by
default puts each user in their own schema, and each user can be
assigned a default tablespace as a property of the user. With the
advent of Tablespace in pg 8.0, is it possible to set a user's default
tablespace?
Alex Turner
NetEco
On Fri, 7 Jan 2005, Brian Maguire wrote:
> Just as an FYI. Sun's Cache rowset which is new and part of the J2SE
> 1.5 is not compatable with Postgres. We have been working with Sun's
> JAVA development team to resolve the issues through our test cases and
> debugging. We hope that in a future
I have been trying for a week now without success to discover
if you can measure the cost of a query (with my c function).
EXPLAIN ANALYZE seems to give you the actual time it took it
to run but the "cost" seems to be a fixed estimate number and not
actual. I see in the code many times references t
Greg Stark <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> writes:
>> You didn't palloc the values array. Any reasonable compiler would have
>> warned you about that BTW. If you don't have compiler warnings enabled,
>> learn to use them.
> I think with gcc this type of warning is only
19 matches
Mail list logo
