Hi all,
I sent the following email to the php mailing list also but maybe this
is a more appropriate mailing list.
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like 5
thanks.
- Original Message -
From: Magnus Hagander [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED];
pgsql-general@postgresql.org
Sent: Friday, September 30, 2005 12:58 PM
Subject: RE: [GENERAL] installing several PostgreSQL instances on Windows
Hello.
Is it possible to
Hello.
There are some columns in my tables that I should
change from varchar to text, in order to have enough space for long textual
commentaries.
Before I do that, I would like to know is there any
restriction regarding text type in comparison to varchar type?
Especially concerning
Hi all,
I sent the following email to the php mailing list also but maybe this
is a more appropriate mailing list.
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like
Hello,
I was using many years ago Sybase that was able then to query several
tables that could be located in more than one database... I know that
Postgresql did not at the time have this capability.
Does the new version 8.0.x ofter this feature? We need to create
several databases based on our
I've written a simple getting started, 'PostgreSQL and Dev-Cpp Dev-C++
on Windows example'. I was wondering if this would be pertinent to post
to pgsql-general or one of the other PG lists?
reid
---(end of broadcast)---
TIP 3: Have you checked
Jim C. Nasby wrote:
On Tue, Sep 27, 2005 at 01:34:37PM +0200, Yonatan Ben-Nes wrote:
Based on http://lnk.nu/developer.postgresql.org/44b.c, line 1478 on,
there's not a lot that happens during the ALTER TABLE. Likewise DROP
(line 517) doesn't do much either. So basically, anything trying to
On Sat, Oct 01, 2005 at 07:12:13PM -0700, Ben wrote:
I'm looking for a quick way to find the number of bits that are
different between two bitmasks of the same size. I'll be doing this a
lot, so speed is desirable some kind of indexing would be even
better. It seems like this problem
On Sun, Oct 02, 2005 at 11:37:10AM +0200, Zlatko Mati? wrote:
There are some columns in my tables that I should change from varchar to
text, in order to have enough space for long textual commentaries.
Before I do that, I would like to know is there any restriction regarding
text type in
On Sun, Oct 02, 2005 at 12:07:18PM +0200, Ben-Nes Yonatan wrote:
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like 5 hours for an update query), from the log
of the
Cosmopo [EMAIL PROTECTED] schrieb:
Does the new version 8.0.x ofter this feature? We need to create
several databases based on our customer's specs... but we need our own
customer, permission, history, etc database. We want to be able to
query 2 database that would have share customer's ID and
Sybase and Microsoft SQL Server are somewhat silimar on
the concept `database'. They both support queries across
multiple databases. But pgsql's database is different,
I think you can use pgsql's schemas to cope with problem.
Regards, William ZHANG
Cosmopo [EMAIL PROTECTED] wrote
Hello,
I
Yes, the Makefiles cannot deal with spaces correctly.
Seems we should avoid use the `complicated' path.
Wes [EMAIL PROTECTED] wrote
System: Mac OS X 10.4.2
PostgreSQL: 8.1 b2
Running 'make check', I get the following failure:
rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh
Martijn van Oosterhout wrote:
On Sun, Oct 02, 2005 at 12:07:18PM +0200, Ben-Nes Yonatan wrote:
I wrote a php script which is running very long queries (hours) on a
database.
I seem to have a problem to run the code when there are single queries
which take long times (like 5 hours for an
Questions: is there a hard limit to the number of schemas you could have
in a database? Are there any caveats/pitfalls/pitbulls to having a
large number of duplicate schemas in a database?
---(end of broadcast)---
TIP 6: explain analyze is your
Am Sonntag, den 02.10.2005, 16:39 +0200 schrieb Ben-Nes Yonatan:
Martijn van Oosterhout wrote:
...
Well this is not the case (sadly.. :)) cause the process is running at
the server without any browser interface.
Use the web as trigger only and a persistent long running process
to read the job
Hello All,
I have a dump file using phpPgAdmin in sql format.
I took this file and then using PgAdminIII ran the sql script on a Windows XP machine.
Though i don't see any errors i can't see the database with tables being created!!!
This approach had worked in the past for me on a Win 2000 box.
Ben-Nes Yonatan [EMAIL PROTECTED] writes:
I seem to have a problem to run the code when there are single queries
which take long times (like 5 hours for an update query), from the log
of the database I received the following code:
2005-09-30 17:12:13 IDT postgres : LOG: 08006: could not send
Yes, that's the straightforward way to do it. But given that my
vectors are 256 bits in length, and that I'm going to eventually have
about 4 million of them to search through, I was hoping greater minds
than mine had figured out how to do it faster, or how compute some
kind of
Steve Manes [EMAIL PROTECTED] writes:
Questions: is there a hard limit to the number of schemas you could have
in a database?
No.
Are there any caveats/pitfalls/pitbulls to having a
large number of duplicate schemas in a database?
If that also implies a large number of tables, you might
--- Reid Thompson [EMAIL PROTECTED] wrote:
I've written a simple getting started, 'PostgreSQL and Dev-Cpp
Dev-C++
on Windows example'. I was wondering if this would be pertinent to
post
to pgsql-general or one of the other PG lists?
If you are asking because of the existence of
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By 'portable'
I mean, I can just unzip files, run the initdb and then run the
postmaster and I get a temporary database server running on port 5432
and accepting connections?
Thanks.
-Samik
On Sun, Oct 02, 2005 at 08:28:53AM -0700, Ben wrote:
Yes, that's the straightforward way to do it. But given that my
vectors are 256 bits in length, and that I'm going to eventually have
about 4 million of them to search through, I was hoping greater minds
than mine had figured out how
Hi all,
I am not expert in PHP, so my assumption may not correct
Can we solve this problem by increasing the max_execution_time
value at php.ini file?
--Nirmalya
--- Ben-Nes Yonatan [EMAIL PROTECTED] wrote:
Hi all,
I sent the following email to the php mailing list also but maybe
Hrm, I'll think about it. Thanks!
On Oct 2, 2005, at 12:50 PM, Martijn van Oosterhout wrote:
On Sun, Oct 02, 2005 at 10:17:10AM -0700, Ben wrote:
Yeah, I thought about this, but damn my 3-dimensional mind, I just
can't convince myself this will work for 256 dimensions. :) Or
rather, I can
On 10/2/05 7:48 AM, William ZHANG [EMAIL PROTECTED] wrote:
Yes, the Makefiles cannot deal with spaces correctly.
Seems we should avoid use the `complicated' path.
Such paths are normal on systems with a GUI interface. They are not out of
the ordinary nor complicated.
Wes
On Sun, Oct 02, 2005 at 10:17:10AM -0700, Ben wrote:
Yeah, I thought about this, but damn my 3-dimensional mind, I just
can't convince myself this will work for 256 dimensions. :) Or
rather, I can see how it could, *given* good placements of the grid
points to snap each vector to.
I found the binary-no-install for 8.0.3 sometime back. Will test it out.
Thanks for your help.
-Samik
On 10/2/2005 3:31 PM, Magnus Hagander wrote:
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By
'portable'
I mean, I can just unzip files, run the initdb and then
Sure, but unless I can figure out some way to choose a small number
of vectors, I'm left with computing the full N^2 set. Given that I'm
shooting for N to be 4 million or larger, that's a lot of data to
store.
On Oct 2, 2005, at 12:14 PM, Todd A. Cook wrote:
Ben wrote:
Just the
Yeah, I thought about this, but damn my 3-dimensional mind, I just
can't convince myself this will work for 256 dimensions. :) Or
rather, I can see how it could, *given* good placements of the grid
points to snap each vector to. Unfortunately, I don't know enough
theory to know what good
Ben wrote:
Just the number of bits, not which ones. Basically, the hamming distance.
I see. Could you pre-compute the bit counts for the vectors in the table?
You could count the bits in the search vector as Martijn suggested, and then
do a lookup based on the count.
-- todd
Samik Raychaudhuri [EMAIL PROTECTED] schrieb:
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By 'portable' I
mean, I can just unzip files, run the initdb and then run the postmaster
and I get a temporary database server running on port 5432 and accepting
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By
'portable'
I mean, I can just unzip files, run the initdb and then run
the postmaster and I get a temporary database server running
on port 5432 and accepting connections?
Um, yes, this should go with any
Just the number of bits, not which ones. Basically, the hamming
distance.
On Oct 2, 2005, at 11:44 AM, Todd A. Cook wrote:
Hi,
It may be that I don't understand your problem. :)
Are you searching the table for the closest vector? If so, is
closeness defined only as the number of bits that
Hi,
It may be that I don't understand your problem. :)
Are you searching the table for the closest vector? If so, is
closeness defined only as the number of bits that are different?
Or, do you need to know which bits as well?
-- todd
Ben wrote:
Hrm, I don't understand. Can you give me an
On Sun, Oct 02, 2005 at 12:15:05PM -0500, Wes wrote:
On 10/2/05 7:48 AM, William ZHANG [EMAIL PROTECTED] wrote:
Yes, the Makefiles cannot deal with spaces correctly.
Seems we should avoid use the `complicated' path.
Such paths are normal on systems with a GUI interface. They are not out
On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo wrote:
Hello,
I was using many years ago Sybase that was able then to query
several tables that could be located in more than one database... I
know that Postgresql did not at the time have this capability.
Does the new version 8.0.x ofter
Thanks for your reply Marc. Yes I am looking at Windows and I was
looking at pginstaller project before emailing. If my understanding is
correct, the project aims developing a Win installer for normal windows
program installation, with registry entries for future uninstallation
etc. What I
Hrm, I don't understand. Can you give me an example with some
reasonably sized vectors?
On Oct 2, 2005, at 10:59 AM, Todd A. Cook wrote:
Hi,
Try breaking the vector into 4 bigint columns and building a multi-
column
index, with index columns going from the most evenly distributed to
the
Any one of the binary packages should allow that ... if you are looking at
Windows, check out the pginstaller project on http://www.pgfoundry.org ...
On Sun, 2 Oct 2005, Samik Raychaudhuri wrote:
Hello Group:
Is there any 'portable' version of PostgreSQL for Windows? By 'portable' I
mean,
Hi,
Try breaking the vector into 4 bigint columns and building a multi-column
index, with index columns going from the most evenly distributed to the
least. Depending on the distribution of your data, you may only need 2
or 3 columns in the index. If you can cluster the table in that order,
it
Wes [EMAIL PROTECTED] writes:
On 10/2/05 7:48 AM, William ZHANG [EMAIL PROTECTED] wrote:
Yes, the Makefiles cannot deal with spaces correctly.
Seems we should avoid use the `complicated' path.
Such paths are normal on systems with a GUI interface. They are not out of
the ordinary nor
On 10/2/05 4:13 PM, Martijn van Oosterhout kleptog@svana.org wrote:
Problem is, the space is also the word seperator. So if you have a
space seperated list of words (ie normal for make), names with spaces
are a pain.
It occurred to me that you might be able to replace the spaces in the
Hi,
Sorry for being so abtuse; my 9 year old has been helping me with my
work today. :)
The hamming distance between two bit vectors can also be found as the
sum of distances between sub-vectors. Let's assume you're looking
for all vectors less than d bits away from a search vector, and we'll
Hi list,
I just downloaded 8.03 source and try to compile the contrib module
intarray by following the instruction in readme. However, I got the
following error:
$ gmake
Makefile:15: ../../src/Makefile.global: No such file or directory
Makefile:16: /contrib/contrib-global.mk: No such file
Le 2005 10 02 14:36, David Fetter a ecrit:
On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo wrote:
Hello,
I was using many years ago Sybase that was able then to query
several tables that could be located in more than one database... I
know that Postgresql did not at the time have this
Jonathan Tse [EMAIL PROTECTED] writes:
I just downloaded 8.03 source and try to compile the contrib module
intarray by following the instruction in readme. However, I got the
following error:
You need to run configure at the top of the distribution tree first.
Be sure to give configure
Samik Raychaudhuri [EMAIL PROTECTED] writes:
... What I wanted is a no-trace (or minimal trace), no-admin required
kind of installation (I won't be able to create a non-admin user in the
comp), which, when I am done, I can just delete the installation
directory and will be clear.
Postgres
48 matches
Mail list logo