From: | "Siah" <siasookhteh(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | SQL & Binary Data Questions |
Date: | 2006-05-19 01:50:51 |
Message-ID: | 1148003451.400322.85610@g10g2000cwb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
I see people use postgreSQL for storing their binary data including
images, etc. Here are a few questions I would very much like to have
expert opinions on:
- Is it not faster / more efficient to store binary data using file
system and let DB keep the path?
- I know of only one way to interact with PostgreSQL and that is using
SQL. Since it has powerful bytea support, I'd to utilize it by storing
my sterilized data structure into the DB. Is this practice recommended
or discouraged? Is there any better method of pushing binary data to
postgres besides parsing it into ascii sql which seems extremely
inefficient to me.
- Does it make my queries any slower if the rows are bundled with
binary data (that has nothing to do with the query)?
I am using python as my backend, and I am programming a web application
for which speed matters.
Thank you,
Sia
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver A. Rojo | 2006-05-19 04:52:12 | invalid byte sequence for encoding error |
Previous Message | Tom Lane | 2006-05-18 23:28:50 | Re: autovacuum "connections" are hidden |