well after many problems i can install sunstudio 11; but now my
problem is:
>
>
> - environment:
> bash-2.05# echo $CC
> /opt/SunStudio/bin/cc
>
> bash-2.05# echo $CFLAGS
> -xarch=v9 -O
>
> - my configure was:
>
> ./configure --with-CC=/opt/SunStudio/bin/cc --with-perl --without-readline
Hi,
I went looking at why some of our queries using some custom functions were
a bit sluggish.
usercandoonobject(integer, integer, character, integer) does this:
IF (isSuperuser(p_user_id)) THEN
RETURN true;
END IF;
RETURN userCanDoOnObjectCheckGod($1, $2, $3, $4);
issuperus
Hi guys,
well definitely thanks for these first ideas. They at least point in a
direction which I havn't considered before (to be honest, I didn't even think
about associating STDOUT with some socket stuff).
With my experiments, I think I have essentially tried both socket types. Once I
normal
On 09/07/10 22:08, Tom Lane wrote:
> Andras Fabian writes:
>>> Something weird about the network stack on the new machine, maybe.
>>> Have you compared the transfer speeds for Unix-socket and TCP connections?
>
>> Hmm, no ... but how do Unix-socket / TCP connections relate to STDOUT here
>> (sor
On 09/07/10 21:36, Tyler Hains wrote:
>> We are having a very strange issue where for certain records, queries
>> sent via JDBC return no results when the identical query via command
>> line or pgadmin return non-null (expected) results. Example below. We
>> are running 8.3.9.
>
> We found our pro
Please reply to the list, not just to me. "reply all" or (in smarter
mail clients) "reply to list" will do the trick.
I've cc'd the list.
On 10/07/10 00:15, Susan Cassidy wrote:
> I didn't set up the cluster (just started working here a few months ago), so
> I don't know for sure. A comment in
Tim: ah, come on. :-P
I do have basic knowledge, and beyond. I am mostly a MySQL dev (dont flame
yet), but have a good grasp on bds in general.
I usually solve the BD problems/situations in a way i can easily code around
it, since i am normally the dev on the programming front also. This time i
a
Miguel Vaz wrote:
> Thank you for the opinion, Alban. The names are the least of my worries, i
> typed them without thinking. And its portuguese. :-)
> If, using that design, i had a different table with something like arq_types
> { id_arq_type, descr } that i could somehow connect to the generi
On 9 Jul 2010, at 17:08, Miguel Vaz wrote:
>
> Thank you for the opinion, Alban. The names are the least of my worries, i
> typed them without thinking. And its portuguese. :-)
>
> If, using that design, i had a different table with something like arq_types
> { id_arq_type, descr } that i coul
On Thu, Jul 8, 2010 at 10:56 PM, tamanna madaan
wrote:
> Hi All
>
> I am using a cluster setup with two nodes in it. Replication between two
> nodes is being done through slony.
>
> Postgres version is 8.1.2 and slony version is 1.1.5 .
>
> I am running an operation that does thousands of update
Thank you for the opinion, Alban. The names are the least of my worries, i
typed them without thinking. And its portuguese. :-)
If, using that design, i had a different table with something like arq_types
{ id_arq_type, descr } that i could somehow connect to the generic table
(the one with the co
Today is your last chance to submit a CFP abstract for the 2010 Surge
Scalability Conference. The event is taking place on Sept 30 and Oct 1,
2010 in Baltimore, MD. Surge focuses on case studies that address
production failures and the re-engineering efforts that led to victory
in Web Application
Andras Fabian writes:
>> Something weird about the network stack on the new machine, maybe.
>> Have you compared the transfer speeds for Unix-socket and TCP connections?
> Hmm, no ... but how do Unix-socket / TCP connections relate to STDOUT here
> (sorry, maybe this is obvious to some, but not
> Something weird about the network stack on the new machine, maybe.
> Have you compared the transfer speeds for Unix-socket and TCP connections?
Hmm, no ... but how do Unix-socket / TCP connections relate to STDOUT here
(sorry, maybe this is obvious to some, but not to me at the moment)?
And doi
Andras Fabian writes:
> Now I ask, whats going on here Why is COPY via STDOUT so much slower on
> out new machine?
Something weird about the network stack on the new machine, maybe.
Have you compared the transfer speeds for Unix-socket and TCP connections?
On a Red Hat box I would try usin
> We are having a very strange issue where for certain records, queries
> sent via JDBC return no results when the identical query via command
> line or pgadmin return non-null (expected) results. Example below. We
> are running 8.3.9.
We found our problem. It turned out to be a config file that w
Hi All
I am using a cluster setup with two nodes in it. Replication between
two nodes is being done through slony.
Postgres version is 8.1.2 and slony version is 1.1.5 .
I am running an operation that does thousands of update/inserts/delete
on some tables. While running update query on
Miguel Vaz wrote:
> I was looking for an opinion on the actual table structure. :-) How should i
> build the data set? Is my second example ok? The first is the long version
> but i wanted to put together all the common fields to both types of "sites"
> and then (maybe) build tables to accomodate
Hej Guys,
I'm looking for design ideas (and implementation specifics, not just
tutorials) to a transaction "heavy" multi-process, multi-threaded system using
PostgreSQL. Are there some good references to existing open source systems for
me to see how other people has solved that kind of p
Hi,
I am new to the mailing list (as a writer ... reading since a long time), but
am using PostgreSQL in our company for quite some time now.
Lately, we rolled out some new servers with vastly improved hardware (8 disk
RAID 1+0, instead of old 2 disk RAID 1 etc. etc.), new OS (Ubuntu 10.04 serve
On 9 Jul 2010, at 3:41, Miguel Vaz wrote:
> and i would like to put these two "sites" in the same data set and maybe add
> a new table called "site types" to categorize each record (maybe a relation
> table to allow many to many): how can i go about doing it? is this solution
> decent enough:
>
Hi, Tim,
I was looking for an opinion on the actual table structure. :-) How should i
build the data set? Is my second example ok? The first is the long version
but i wanted to put together all the common fields to both types of "sites"
and then (maybe) build tables to accomodate the specific field
Hello all,
I am learning PostgreSQL PITR. I have PostgreSQL running with the
following parameters
set up for archiving/log switching:
archive_mode = on
archive_command = 'cp -i %p /home/postgres/archive/%f http://www.postgresql.org/mailpref/pgsql-general
Miguel Vaz wrote:
> [...]
> * sites (generic):
> id_site
> name
> description
> x
> y
> * site_natural
> id
> id_site
> altitude
> * site_arqueology
> id
> id_site
> id_category
> id_period
> But i seem to be missing something. How can i have this in a way that its
> easy to list only "arqueo
Dave Page, 09.07.2010 10:20:
So how do I download the "binaries only" (no installer) bundle of Postgres
8.3 for windows?
EnterpriseDB don't produce one for 8.3. There is a copy from the old
MSI installer at http://www.postgresql.org/ftp/binary/v8.3.11/win32/,
but it's not binary-compatible with
On Fri, Jul 9, 2010 at 9:14 AM, Thomas Kellerer wrote:
> Hi,
>
> I'm trying to download the ZIP archive for Postgres 8.3 on Windows, but I
> can't find a download location where I do not need to register with
> EnterpriseDB
>
> When I go to http://www.enterprisedb.com/products/download.do and clic
Hi,
I'm trying to download the ZIP archive for Postgres 8.3 on Windows, but I can't
find a download location where I do not need to register with EnterpriseDB
When I go to http://www.enterprisedb.com/products/download.do and click on the Windows
link for Postgres 8.3 I end up on the "Please re
27 matches
Mail list logo
