On Mon, Jun 13, 2011 at 3:27 AM, Merlin Moncure mmonc...@gmail.com wrote:
I would not even consider tweaking the internal block sizes until
you've determined there is a problem you expect you might solve by
doing so.
It's not a problem as such, but managing data chunks of 2000 bytes +
the
On Tue, Jun 14, 2011 at 6:48 AM, Hanno Schlichting ha...@hannosch.eu wrote:
On Mon, Jun 13, 2011 at 3:27 AM, Merlin Moncure mmonc...@gmail.com wrote:
I would not even consider tweaking the internal block sizes until
you've determined there is a problem you expect you might solve by
doing so.
On 13/06/11 09:27, Merlin Moncure wrote:
want to use the binary protocol mode (especially for postgres versions
that don't support hex mode)
Allowing myself to get a wee bit sidetracked:
I've been wondering lately why hex was chosen as the new input/output
format when the bytea_output change
On Mon, Jun 13, 2011 at 1:58 AM, Craig Ringer
cr...@postnewspapers.com.au wrote:
On 13/06/11 09:27, Merlin Moncure wrote:
want to use the binary protocol mode (especially for postgres versions
that don't support hex mode)
Allowing myself to get a wee bit sidetracked:
I've been wondering
Hi.
I'm a new Postgres user. If I happen to ask stupid questions please
feel free to point me to any documentation I should read or guidelines
for asking questions.
I'm looking into storing binary data in Postgres and trying to
understand how data is actually stored in the database. The dataset
Le dimanche 12 juin 2011 à 18:00 +0200, Hanno Schlichting a écrit :
I'm looking into storing binary data in Postgres and trying to
understand how data is actually stored in the database. The dataset
I'm looking at is images, photos, pdf documents which should commonly
be at a minimum 100kb,
On 6/12/11 12:00:19 PM, Hanno Schlichting wrote:
Hi.
I'm a new Postgres user. If I happen to ask stupid questions please
feel free to point me to any documentation I should read or guidelines
for asking questions.
I'm looking into storing binary data in Postgres and trying to
understand how
On 06/13/2011 12:00 AM, Hanno Schlichting wrote:
But from what I read of Postgres, my best bet is to store data as
large objects [2]. Going all the way down this means storing the
binary data as 2kb chunks and adding table row overhead for each of
those chunks. Using the bytea type and the
On Sun, Jun 12, 2011 at 11:00 AM, Hanno Schlichting ha...@hannosch.eu wrote:
Hi.
I'm a new Postgres user. If I happen to ask stupid questions please
feel free to point me to any documentation I should read or guidelines
for asking questions.
I'm looking into storing binary data in Postgres
