Hi Michael,
I have recently been working on a database which is presently 14 GB in
size and will grow to nearly 1/2 terabyte in the next 12 months. This
database is mostly large static two column tables needing fast searches.
So far what I've done is split the table into various subtables - for
Hello there,
I have a DB that I am attempting to buy "the right hardware" for.
This DB today is about 25GB total, with typical tables in the area of 3GB in
size, and up to about 20 million records per table for the big tables.
Is there any set of recommendations for sizing a DB using PostgreSQL
You can create a case insensitive, unique index like this:
CREATE UNIQUE INDEX indexname ON tablename (lower(fieldname))
Michael Fork - CCNA - MCP - A+
Network Support - Toledo Internet Access - Toledo Ohio
On Tue, 30 Jan 2001, Culley Harrelson wrote:
> is there a way to make a unique index ca
is there a way to make a unique index case insesitive
for text data? I can change case in my front end code but I
thought I'd ask :)
Here are some good references on using triggers:
http://www.postgresql.org/docs/aw_pgsql_book/node204.html
http://www.postgresql.org/users-lounge/docs/7.0/user/c40874113.htm
These docs show you how to create a trigger, and use the information
contained in the new tuple for calculations
Mich
Yes, but how can I pass a reference of the row just inserted to the
trigger??
adb wrote:
>
> Sounds like you need to use a trigger set to
> fire after the insert on table A
>
> Alex.
>
> On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote:
>
> > I read at the docs that rules are executed bef
Sounds like you need to use a trigger set to
fire after the insert on table A
Alex.
On Tue, 30 Jan 2001, Nelio Alves Pereira Filho wrote:
> I read at the docs that rules are executed before the query that
> generated them. Is there any way to change this?
>
> Here's my problem: I have two tabl
On Tue, 30 Jan 2001, Jeff wrote:
> I have a design question. Lets say we want to keep track of users and
> their respective snail mail addresses. Each user can have up to 4
> different mailing address. Is it better to have all this information in
> one table.
Only if you have mostly 4 address
I read at the docs that rules are executed before the query that
generated them. Is there any way to change this?
Here's my problem: I have two tables, A and B, and after an INSERT on
table A, I want to update an specific field on table B, with the result
of a sum in A. To do this I needed some i
Tom Lane <[EMAIL PROTECTED]> writes:
> If you want to force things to happen then you should send SIGINT to
> the postmaster, which in turn will SIGTERM its backends, which in
> theory will abort their transactions and shut down. (No, this isn't
> real consistent, but we wanted the right things
Is it important the above NOTICE message?
What does it mean?
--
Evelio Martínez
Testanet. Dept. desarrollo software.
Av. Reino de Valencia, 15 - 5
46005 Valencia (Spain)
Tel: +34 96 395 90 00
Fax: +34 96 316 23 19
DROP TABLE fam;
DROP TABLE subfam;
DROP TABLE pro;
DROP SEQUENCE fam_idfam
I don't know what it means; but I kept getting similar
message when accessing a PostgreSQL 7.0.3 table via
ODBC from MS Access. As it was occurring with one
table only, I deleted the link and reattached the
table. This seemed to solve the problem.
I hope this helps,
Andrew Gould
--- Steven L
I'd like to know in what order are rules executed, comparing to the
queries that generated them.
For instance, supose that a INSERT on table A has a rule to update a
column in table B. What will be executed first: the INSERT or UPDATE?
Tks
--
Nelio Alves Pereira Filho
IFX Networks - www.ifx.com
I get this error from time to time.
What does this mean, How can I correct it
ADODB.Recordset.1, 80004005, Error while executing the query;
Could not send Query to backend;
Could not flush socket buffer.
Now I just need someone to write me a note and get me out of work. ;)
I'd be going up from the philly area also.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
> Each user can have up to 4
> different mailing address. Is it better to have all this information in
> one table. Or is it better to have a user table and an address table,
> and have the user id as a foreign key in the address table?
It's even possible (recommended by the books) to have sepa
Plus, it allows you to add more functionality later. Say you later want to
keep track of phone numbers. Add another table with a phone number field
linked to the master table with the users instead of making your one table
consistently larger.
Adam Lang
Systems Engineer
Rutgers Casualty Insuran
On Tue, 30 Jan 2001, Jeff wrote:
> I have a design question. Lets say we want to keep track of users and
> their respective snail mail addresses. Each user can have up to 4
> different mailing address. Is it better to have all this information in
> one table. Or is it better to have a user tab
Depends on your needs. Typically I would always break out the addresses
into another table, since it's much more flexible. creating four separate
address fields in the user table will reduce the need to perform joins and
thus perhaps make your schemea a little simpler, and your queries a little
> That's right. Half-day tutorials actually start today, but the
> conference and exhibits start Wednesday.
>
> Regards,
> Ned
Also, you can download a free exhibit pass at:
http://www.greatbridge.com/download/LWEXP12_12.pdf
--
Bruce Momjian| http://candle
That's right. Half-day tutorials actually start today, but the
conference and exhibits start Wednesday.
Regards,
Ned
os390 ibmos wrote:
> Just a quick non-postgress digression about the Linux
> expo exhibition/show dates, as per my info it's wednesday thru friday
> (10A-6P) ?
>
> Don't wa
I have a design question. Lets say we want to keep track of users and
their respective snail mail addresses. Each user can have up to 4
different mailing address. Is it better to have all this information in
one table. Or is it better to have a user table and an address table,
and have the user
Oh well, I wish I knew ahead of time... boss said it is too short of
notice... blah.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Adam Lang" <[EMAIL PROTECTED]>
Cc: "PostgreSQL-
"Adam Lang" <[EMAIL PROTECTED]> writes:
> Location of Linux World? Links to find info? I didn't know about it.
It's at Javits Convention Center in NYC, today through Friday.
See http://www.linuxworldexpo.com/
regards, tom lane
Location of Linux World? Links to find info? I didn't know about it.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "PostgreSQL-announce" <[EMAIL PROTECTED]>;
"PostgreSQL-ge
Is there a way to grant a user with all privileges on a database? Something
like Informixs GRANT dba?
--
System Administration: It's a dirty job,
but someone told I had to do it.
-
Martín Marqués email: [EMAIL PR
Hi, out there!
Here is my problem: I'm building an intranet/internet application for
publishing materials (photo & text databeses) and for this purpose I need a
reliable, fast and unexpensive database backend. In this order I need some
advice regarding PostgreSQL.
Here are some technical informat
Hello,
Can I calculate size of table in postgresql and how ?
Haris Peco
[EMAIL PROTECTED]
What a suprise to see my e-mail as part of the screenshot of Gmail...
In a moment I thought that you had written a custom script that overide
the gif to make it look like it is coming from me by extracting info
from my http session...
Gmail looks great except it doesn't do IMAP which I need to a
Quoting "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>:
> A few days ago I posted a query regarding a problem I had with errors I
> was
> incurring doing some nested queries with the jdbc driver. (having
> recently
> done a re-install my email history is in limbo for the moment)
>
> Found some of my
30 matches
Mail list logo