Thanks to both of you. I tried the following and got an error that
plpython.dll couldn't be found:
D:\postgresql\bin>createlang -U sauser plpythonu mydb
Password:
createlang: language installation failed: ERROR: could not load library
"D:/pos
tgresql/lib/plpython.dll": The specified module could
Clodoaldo wrote:
A web application will store hundreds of thousands images.
What is the best practice in this situation? I mean not only the two
options as above but any.
This discussion comes up regularly. See the archives for a thread
titled "Storing images in PostgreSQL databases (aga
novnov <[EMAIL PROTECTED]> writes:
> - Per most docs the installation of a language is done with createlang. I've
> tried many times and cannot get the syntax right. Typically I log in to psql
> in the \bin directory as the main postgres user. After that, a typical
> attempt is looks like this:
>
On Sunday 31 December 2006 2:09 pm, novnov wrote:
> I've spent a couple of hours on this and would like to ask for an assist at
> this point. I need to install python support on windows. The postgresql
> install is the windows 8.2.0-1 binary, and pl/pgsql was included in the
> initial installation.
Hello!
I'm only moderately familiar with postgres and the DBI related modules that
I'm using to access it so forgive me if this is a simple question. I've been
looking for several hours for information on this and have not found a
satisfying answer.
I'm writing a simple CGI application to do sim
I've spent a couple of hours on this and would like to ask for an assist at
this point. I need to install python support on windows. The postgresql
install is the windows 8.2.0-1 binary, and pl/pgsql was included in the
initial installation. I have python 2.5 installed. The workstation's path
does
A web application will store hundreds of thousands images.
The images meta data will be stored in postgresql but I'm in doubt
about where to store the images themselves, if in the database as byte
strings or in the file system.
Would one of them have a faster image search than the other?
In the
Thanks Adrian, I'll see what I can do with that, I'll learn a lot by going
through what you've done.
Adrian Klaver wrote:
>
> On Sunday 31 December 2006 8:48 am, novnov wrote:
>> OK. python would be the preference, if anyone is interested in showing me
>> how it would be done, I've never used o
Yes thanks that does make it clear.
Martijn van Oosterhout wrote:
>
> On Sun, Dec 31, 2006 at 08:48:07AM -0800, novnov wrote:
>> Why would not be possible in plpgsql? It has loop etc, the only part I'm
>> not
>> sure it can do it use the variable as field name.
>
> The "dynamic" in dynamic lan
On Sunday 31 December 2006 8:48 am, novnov wrote:
> OK. python would be the preference, if anyone is interested in showing me
> how it would be done, I've never used one of the dynamic languages with
> postgres.
>
> Why would not be possible in plpgsql? It has loop etc, the only part I'm
> not sure
On 12/31/06, Nikola Milutinovic <[EMAIL PROTECTED]> wrote:
> 1. There is no difference (speed-wise) between committing every 1K or
every 250K rows.
It was really some time ago, since I have experimented with this. My las
experiment was on PG 7.2 or 7.3. I was inserting cca 800,000 rows.
Inserti
> It was really some time ago, since I have experimented with this. My las
> experiment was on PG
> 7.2 or 7.3. I was inserting cca 800,000 rows. Inserting without transactions
> took 25 hrs.
> Inserting with 10,000 rows per transaction took about 2.5 hrs. So, the
> speedup was 10x. I have
> not
On Sun, Dec 31, 2006 at 08:48:07AM -0800, novnov wrote:
> Why would not be possible in plpgsql? It has loop etc, the only part I'm not
> sure it can do it use the variable as field name.
The "dynamic" in dynamic language usually refers to dynamic typing.
pl/pgsql is a strictly typed language which
When responding just now I mentioned loops because another issue I'm working
on involves those, loops wouldn't be involved here.
novnov wrote:
>
> OK. python would be the preference, if anyone is interested in showing me
> how it would be done, I've never used one of the dynamic languages with
OK. python would be the preference, if anyone is interested in showing me how
it would be done, I've never used one of the dynamic languages with
postgres.
Why would not be possible in plpgsql? It has loop etc, the only part I'm not
sure it can do it use the variable as field name.
David Fetter
> 1. There is no difference (speed-wise) between committing every 1K or every
> 250K rows.
It was really some time ago, since I have experimented with this. My las
experiment was on PG 7.2 or 7.3. I was inserting cca 800,000 rows. Inserting
without transactions took 25 hrs. Inserting with 10,00
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Alvaro Herrera)
wrote:
> Christopher Browne wrote:
>
>> Seems to me that you could get ~80% of the way by having the
>> simplest "2 queue" implementation, where tables with size < some
>> threshold get thrown at the "little table" queu
17 matches
Mail list logo
