On Mon, 17 Apr 2000, Titus Brown wrote:
> -> >I have got a form on my site, that can be filled in by visitors. I want the
> -> >results automatically being written in my sql database, does anybody know
> -> >how to do this???
There is more than one way to do it!
> -> Whatever platform you use,
Hello,
I struggled (just a little) to get the new RC1 RPMS installed and
working. The first thing I did was to backup my existing
database:
pg_dump stocks > stocks
Things went fine. I then uninstalled the existing RPMS using
GnoRPM. I downloaded the following RPMS from postgresql.org:
postgres
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I have completed the first draft of my book through chapter 14.
> New chapters include:
> The books is accessible at:
> http://www.postgresql.org/docs/awbook.html
> Comments welcomed.
Thanks for your great book! But the latest version of it
To backup the postgres database on one of our
servers, we use pg_dump to dump the table to
a file. Now, we have a table that has around
300,000 records (iirc) but when pg_dump tries
to dump it, its size (in ps) grows to 270M
and the machine swaps like mad.
This is surely an error. I've temporaril
Hello,
I have a table with two attributes x and y. The table is indexed on y.
Now, From a C program I want to fetch first n tuples from the table by
doing an indexscan(on index y) on the table. what should I do?
Currently I am able to do it using a cursor(using a select stmt that
forces an inde
Mike Mascari wrote:
First of all, THANK YOU! Now, on to the list
> rm -rf /var/lib/pgsql
> I'm sure that most people would have performed an upgrade (rpm
> -Uvh), but, ironically enough, I prefer to uninstall and
> reinstall for safety's sake. Somehow, that should work :-(. Now I
> tried
> > No manual entry for pg_ctl
> Waiting on that man page
The man pages are done and available at a secret, hidden location ;)
Try something like
http://www.postgresql.org/user-lounge/7.0/docs/man.tar.gz
- Thomas
--
Thomas Lockhart [EMAIL PR
On Tue, 18 Apr 2000, Lincoln Yeoh wrote:
> At 08:29 PM 17-04-2000 +0100, Peter Mount wrote:
> >On Mon, 17 Apr 2000, Adam Ruth wrote:
> >
> >> > I'm using Linux and ext2fs has a 2GB limit on files, and it seems like
> >> > 6.5.3 tables are stored as single files, so better not go down that path
>
I'm starting a new project. We've selected PostgreSQL and I'm wondering if
we shouldn't just jump in with 7.0 and avoid conversion hassles later on. I
guess the issues for me are:
1. Stability. How good is Beta 5 (it is 5 now isn't it?)
2. Documentation. Are the docs ready?
3. Support. Wh
Thomas Lockhart wrote:
>
> > > No manual entry for pg_ctl
> > Waiting on that man page
>
> The man pages are done and available at a secret, hidden location ;)
To be accessed by my Captain Postgres Secret Decoder Ring (TM)? ;-)
If these man pages are going into the 7.0 final (or an RC2, if
Joseph wrote:
You're also asking everyone who reads this newsgroup to send you a
reciept. Could you turn that auto-ask-for-a-reciept feature off,
please?
Ron Peterson
[EMAIL PROTECTED]
"Michael S. Kelly" wrote:
>
> I'm starting a new project. We've selected PostgreSQL and I'm wondering if
> we shouldn't just jump in with 7.0 and avoid conversion hassles later on.
Yes.
I haven't seen any discussions on this list since 7.0beta1 was released
that would indicate you should be co
I'm working a piece on open-source databases for LinuxWorld magazine and
I'd like to know what people are actually using postgresql for.
--Rick Cook
[EMAIL PROTECTED]
> Does anyone have any experience using Postgres's full-text indexing in a
> production environment? We're thinking about using it for a project (the
> other solution is to regexp it with Perl...). I've set up the stuff
> before for experimentation, but am mainly curious about it's performance
>
[EMAIL PROTECTED] wrote:
>
> I'm working a piece on open-source databases for LinuxWorld magazine and
> I'd like to know what people are actually using postgresql for.
I'm using it for mission-critical intranet applications in our broadcast
radio station, backing the AOLserver webserver. I am a
At 08:40 PM 18/04/00 -0400, Bruce Momjian wrote:
>I have one word for you: CLUSTER. Without it, index lookups are too
>slow. With it, they are rapid. I have done some work like this
>commerically with Ingres, which has an ISAM type that keeps the matching
>rows pretty close on a newly-created
> At 08:40 PM 18/04/00 -0400, Bruce Momjian wrote:
>
> >I have one word for you: CLUSTER. Without it, index lookups are too
> >slow. With it, they are rapid. I have done some work like this
> >commerically with Ingres, which has an ISAM type that keeps the matching
> >rows pretty close on a n
On Tue, 18 Apr 2000, Bruce Momjian wrote:
> I have one word for you: CLUSTER. Without it, index lookups are too
> slow. With it, they are rapid. I have done some work like this
> commerically with Ingres, which has an ISAM type that keeps the matching
> rows pretty close on a newly-created IS
On Tue, 18 Apr 2000, Bruce Momjian wrote:
> > I agree! The last bit of advice given in the full text README. As I
> > said, I'd built full-text stuff for experimentation (I had maybe 30k of
> > raw text, which amounted to several 100,000 indexed entries), and I had
> > clustered it, and it was
> On Tue, 18 Apr 2000, Bruce Momjian wrote:
>
> > I have one word for you: CLUSTER. Without it, index lookups are too
> > slow. With it, they are rapid. I have done some work like this
> > commerically with Ingres, which has an ISAM type that keeps the matching
> > rows pretty close on a newl
> On Tue, 18 Apr 2000, Bruce Momjian wrote:
>
> > > I agree! The last bit of advice given in the full text README. As I
> > > said, I'd built full-text stuff for experimentation (I had maybe 30k of
> > > raw text, which amounted to several 100,000 indexed entries), and I had
> > > clustered it,
On Tue, 18 Apr 2000, Bruce Momjian wrote:
> Let me be specific. The problem is that without cluster, your fragment
> rows are together in the index, but are all over the heap table, so you
> have to read in all those disk buffers, and that is slow. With cluster,
> most of your matching fragment
On 18 Apr 2000, Manuel Lemos wrote:
> I may be mistaken, but the last time that I looked at Perl DBI, it didn't
> seem to a complete database abstraction layer than it is needed. For
> instance, you want retrieve data from date fields the results come
> formatted in a database dependent way. Th
I'm just getting into functions in postgres and I've bumped up against a
couple issues which I think I need explained. I've had a wee read of the
archives on this but haven't turned up to much. I think it may be a
conceptual problem on my part though :)
Is it possible on postgres, using pl/pgsql
24 matches
Mail list logo
