Hi ,
We are using pg as oracle alternative on ~30 production db servers.
Also we are planing to migrate all oracle servers to pg if we can get
stable config.
After 6 m. of intensive use of systems by diferent customers we do not
know what for filesystem to install.
In this time we are using linu
Hi,
> Anyone that that is using Postgres for storage and retrival of
> images please post your experiences.
I've been very happy with a web application I built which stores
images in Postgresql in text format. I use PHP to base_64 encode
the binary image file into a text string and store that.
Jeff Boes <[EMAIL PROTECTED]> writes:
> At some point in time, [EMAIL PROTECTED] (Tom Lane) wrote:
>> UnUsed is the number of empty line-pointer slots. At 4 bytes apiece,
>> this would have to vastly exceed the number of live tuples before you
>> should worry much.
> For which values of "vastly"?
Hello,
Try SQlite. It is small DB with SQL 92 standard - almost
implemented. If you need something fast and small it is
just for you.
BTW: it is embadded system, so concurency... is not in the
focus ;)
--
Regards
Michal Zaborowski (TeXXaS)
http://sqlite4delphi.sourceforge.net/
---
At some point in time, [EMAIL PROTECTED] (Tom Lane) wrote:
>Jeff Boes <[EMAIL PROTECTED]> writes:
>> The "Keep" and "UnUsed" numbers seem high to me, compared to other tables. Can
>> anyone interpret these and tell me anything about what we could do with this
>> table to make it "look" better?
>
>
Jeff Boes <[EMAIL PROTECTED]> writes:
> The "Keep" and "UnUsed" numbers seem high to me, compared to other tables. Can
> anyone interpret these and tell me anything about what we could do with this
> table to make it "look" better?
"Keep" is the number of rows that are committed dead but had to be
I'm storing images and files in the database. I have a database server
with all of the binaries and several web servers that attach to it.
The web servers are for load balancing and each maintain a cache of
image files locally. It is the cached images that are served by the
web servers. Whe
To test your theory about COMMIT; BEGIN; you could check the PostgreSQL log,
it is likely to contain a line:
WARNING: there is no transaction in progress
"Jeff Boes" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Our largest (by total byte count) table has a nearly-equal flow of da
The db was initialized for 4 months. And in rest I did nothing regarding the
initialization.
I solved the problem by delete/reinit the database. I really don't know what
caused this.
A day before I noticed the problem I made a "live update" for suse 8.2. I
will look also the log files, maybe I fin
Ah, I should have added: we are using PG 7.3.4.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
> > Also, this is a rework of an existing system and dates are stored as
> > strings. I don't like it but I'm stuck with it for now. I was hoping to
be
> > able to provide some DB level validation of the dates as '-MM-DD'
but I
> > havn't come across a neat way to do it yet. I also hope that
Our largest (by total byte count) table has a nearly-equal flow of data in and
out on a daily basis (that is, we add some 40k rows during the day, and then
every night expire stuff that is timestamped beyond our cutoff, which results in
about 40k deletions).
After the deletions, the table gets vac
I give an example:
These are the datas from the table names:
id n1 n2
1 AaAa AaAa
2 X X
3 A A
4 a a 5
ab ab 6 _Y
_Y 8 ..a ..a
9 .x .x 7
...a ...a
If I run: select * from names order by
n1: the result is:
id
Hi Bruno,
> > I want to use domains in the project I'm working on right now. I'd like
to
> > hear from anyone with experience of using them. Basically I'd like to
know
> > if you think it's a good idea, and whether there are any pitfalls that I
> > should be aware of. I did a quick search on the l
Hello
SELECT CASE WHEN ((SELECT class3.relname FROM pg_class class3, pg_index WHERE ((class1.oid = pg_index.indexrelid) AND (class3.oid = pg_index.indrelid))) IS NOT NULL) THEN (SELECT class3.relname FROM pg_class class3, pg_index WHERE ((class1.oid = pg_index.indexrelid) AND (class3.oid = pg_inde
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 25 November 2003 9:15 am, Tom Lane wrote:
> Jonathan Gardner <[EMAIL PROTECTED]> writes:
> > I have a bit of a problem getting PostgreSQL 7.4's configure script to
> > recognize openSSL.
>
> Weird. Maybe some header that ssl.h depends on is
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 25 November 2003 9:13 am, Joe Conway wrote:
> ./configure --with-openssl --with-krb5=/usr/kerberos
That seems to do the trick. Thanks for the help!
- --
Jonathan Gardner
[EMAIL PROTECTED]
Live Free, Use Linux!
-BEGIN PGP SIGNATURE
I'm after experiences similar to what you are describing with lo_export. I have used
lo_import and ol_export to test image storage and retrival. One problem that you
mention is with super user access required to export to the local file system. The
second problem is that it seems to add another
Are there many images?
I do not suggest to store the images in the database. Better save them on
the disk and in the database save only the path to the image. Think also to
the size of the dump(with images).
It is more easy to handle this way.
This is my opinion.
Best regards.
Andy.
- Orig
Hi all.
One of our clients wants to store images into his postgres database
hosted by us.
To do this is trying to use the PHP function pg_lo_import, receiving
this error message from server:
Waning: pg_query() [function.pg-query]: Query failed: ERROR: You must
have Postgres superuser privileg
The db was initialized for 4 months. And in rest I did nothing regarding the
initialization.
I solved the problem by delete/reinit the database. I really don't know what
caused this.
A day before I noticed the problem I made a "live update" for suse 8.2. I
will look also the log files, maybe I fin
21 matches
Mail list logo
