On Tue, Sep 4, 2012 at 9:06 PM, Ondrej Ivanič wrote:
> Hi,
>
> On 5 September 2012 12:14, Chris Travers wrote:
>
> > So people are using PostgreSQL in roles that aren't very visible anyway,
> > DBA's are usually coming to PostgreSQL from other RDBMS's, and few
> > applications are really distribu
Hi, Seref. You might want to take a look at Stado:
http://www.slideshare.net/jim_mlodgenski/scaling-postresql-with-stado
Best,
-at
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Wed, Aug 22, 2012 at 7:21 PM, Chris Travers wrote:
> Does Postgres-XC support query parallelism (at least splitting the
> query up for portions that run on different nodes)? They just
> released 1.0. I don't know if this sort of thing is supported there
> and it might be overkill at any rate.
Hi,
On 5 September 2012 12:14, Chris Travers wrote:
> So people are using PostgreSQL in roles that aren't very visible anyway,
> DBA's are usually coming to PostgreSQL from other RDBMS's, and few
> applications are really distributed for PostgreSQL.
>
> Not only
> this but there was significan
On 05/09/12 08:38, Scott Marlowe wrote:
On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower
wrote:
On 05/09/12 05:35, Scott Marlowe wrote:
I have read to emails to one of the postgresql lists,
where people in companies with 1000's of databases had
power failures and only the postgresql databases
resta
On Tue, Sep 4, 2012 at 7:21 PM, John R Pierce wrote:
> On 09/04/12 7:09 PM, Aleksey Tsalolikhin wrote:
>>
>> BTW, after I signalled TERM, the process status changed from
>>
>> notify interrupt waiting
>>
>> to
>>
>> notify interrupt waiting waiting
>>
>> which I thought looked kind of odd.
>>
>> T
On 09/04/12 7:09 PM, Aleksey Tsalolikhin wrote:
BTW, after I signalled TERM, the process status changed from
notify interrupt waiting
to
notify interrupt waiting waiting
which I thought looked kind of odd.
Then I signalled KILL.
was this a client process or a postgres process? kill -9 on
On Tue, Sep 4, 2012 at 10:35 AM, Scott Marlowe wrote:
>
>
> Since there's no reporting requirements for using postgresql
> commercially etc, it's kind of a stealth database. It's all over the
> place and nobody knows it. Meanwhile, finding qualified PostgreSQL
> DBAs is pretty tough because of i
BTW, after I signalled TERM, the process status changed from
notify interrupt waiting
to
notify interrupt waiting waiting
which I thought looked kind of odd.
Then I signalled KILL.
Aleksey
On Tue, Sep 4, 2012 at 6:21 PM, Aleksey Tsalolikhin
wrote:
> Hi.
>
> We use LISTEN/NOTIFY quite a bit
On Sep 4, 2012, at 21:39, Sergio Basurto wrote:
> I am using regexp_matches in a function like this
>
> create or replace function test (v_string in text) returns varchar as $$
> declare
> i_strings text[];
> i_stringtext[];
>
> i_strings :=
> regexp
I am using regexp_matches in a function like this
create or replace function test (v_string in text) returns varchar
as $$
declare
i_strings text[];
i_stringtext[];
i_strings := regexp_matches(v_string,E'[a-zA-Z0-9:\\s\\-\\.#%
]*:[A-Za-z0-9\\s\\-\\.#%]+
Hi.
We use LISTEN/NOTIFY quite a bit but today something unusual (bad) happened.
Number of processes waiting for a lock just started to go up up up.
I finally found the object being locked was pg_listener which
RhodiumToad on IRC kindly informed happens during LISTEN/NOTIFY. The
process that ha
Since this PGCon 2011 page has no slides -
http://www.pgcon.org/2011/schedule/events/361.en.html
I Googled for "sharding" and "PostgreSQL" and I found this -
http://www.databasesoup.com/2012/04/sharding-postgres-with-instagram.html
"On Tuesday last week we had a terrific SFPUG meeting at which
On Tue, Sep 4, 2012 at 3:13 PM, Gavin Flower
wrote:
> On 05/09/12 08:38, Scott Marlowe wrote:
>
> On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower
> wrote:
>
> On 05/09/12 05:35, Scott Marlowe wrote:
> I have read to emails to one of the postgresql lists,
> where people in companies with 1000's of da
Excellent :)
Thanks - looks as acceptable workaround...
Many thanks,
Misa
2012/9/5 Joe Conway
> On 09/04/2012 04:45 PM, Misa Simic wrote:
> > Hi Joe,
> >
> > Do you maybe know, is it possible inside PL/R to call another PL/R
> > function - but take result as R object (whatever R function retu
On 09/04/2012 04:45 PM, Misa Simic wrote:
> Hi Joe,
>
> Do you maybe know, is it possible inside PL/R to call another PL/R
> function - but take result as R object (whatever R function returns)?
Mmmm, what about using plr_modules table?
It creates native R functions that get installed into your
On 09/05/2012 09:11 AM, Claire Chang wrote:
Has anyone done that successfully? Is there any better way to sync data
between SQL server 2012 and Postgres SQL 9?
If you're going to cross-post between Stack Overflow and the PostgreSQL
mailing list, please consider mentioning the fact to reduce t
>
> (what btw forced me to check it in plv8 - and it seems they use the same
> approach internally in behind :( - though doesn't make sense because of
> find_function works just with plv8 postgres functions)
Just realised I have called wrong method - so above is not true... it
returns real v8 ob
Hi Joe,
Do you maybe know, is it possible inside PL/R to call another PL/R function
- but take result as R object (whatever R function returns)?
If we take this scenario for example (Take some data from DB, pivot them,
and save it as CSV)... pseudo code would be:
-Execute SQL query
-pivot return
On 09/04/2012 02:59 PM, Aram Fingal wrote:
> On Sep 4, 2012, at 4:36 PM, A.M. wrote:
>
>> Or you could return the heatmap/plot as BYTEA data or use arrays as
>> necessary.
>
> I was actually thinking exactly the same thing. Part of the reason I
> use PostgreSQL for all my bioinformatics work is
Has anyone done that successfully? Is there any better way to sync data between
SQL server 2012 and Postgres SQL 9?
Thanks,
Claire
On Sep 4, 2012, at 4:36 PM, A.M. wrote:
> Or you could return the heatmap/plot as BYTEA data or use arrays as necessary.
I was actually thinking exactly the same thing. Part of the reason I use
PostgreSQL for all my bioinformatics work is that there is a need to correctly
associate analysis r
Subject changed to describe the problem. Reply in-line.
On 09/04/2012 07:57 PM, Herouth Maoz wrote:
The issue is that when an insert or an update is fired, I can't say
whether all the segments of the same transaction have been written yet,
and if only some of them were written, there is no guar
On 09/04/2012 01:23 PM, Aram Fingal wrote:
> So then, PL/R is not a solution to being able to pivot tables
> directly in PostgreSQL but I might be able to define a PL/R procedure
> which, for example, pivots tables and then uses the write.table()
> function of R to send the results to disk without
On Tue, Sep 4, 2012 at 10:39 AM, punnoose
wrote:
> hi all
> How could i use crostab to display variable number of columns. in the output
> There could be variable number of columns
> Regards
> Punnoose
No. The workaround I use is to write a query generator in pl/pgsql
(you can also do it in the
That is correct,
Re you additional question re PL/R or get data from Pg in plain R - I am
not sure it will be that much faster inside PL/R...
I dont think there will be too much difference in execution time... Would
be good to test it... and would be good to share results with us :)
Thanks,
Mis
On Tue, Sep 4, 2012 at 2:03 PM, Gavin Flower
wrote:
> On 05/09/12 05:35, Scott Marlowe wrote:
> I have read to emails to one of the postgresql lists,
> where people in companies with 1000's of databases had
> power failures and only the postgresql databases
> restarted without special recovery act
On Sep 4, 2012, at 4:30 PM, Aram Fingal wrote:
>
> On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
>
>> Inside PL/R you can take the same table as it is (unpivoted) as your
>> data.frame and then pivot it inside R using reshape package,,, And then
>> inside PL/R function do whatever you would l
On Sep 4, 2012, at 4:18 PM, Misa Simic wrote:
> Inside PL/R you can take the same table as it is (unpivoted) as your
> data.frame and then pivot it inside R using reshape package,,, And then
> inside PL/R function do whatever you would like to do with data i.e export to
> whatever... - but you
No,
you must use AS (..) in crosstab query...
To actually, be able to create AS on "unkown" data in design time, what
should produce an "unknown" result and unknown number of columns we are
using Dynamic SQL to build AS part... (but of course function can't return
result - just for export to csv
On Sep 4, 2012, at 3:56 PM, Joe Conway wrote:
> On 09/04/2012 12:48 PM, Aram Fingal wrote:
>> So, are you saying that if I do something like this:
>>
>> copy(crosstab(source_sql, category_sql)) to '/output.csv' with csv;
>>
>> Then I don't have to list what the columns are going to be? In othe
On 05/09/12 05:35, Scott Marlowe wrote:
On Tue, Sep 4, 2012 at 11:28 AM, Mike Christensen wrote:
On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak wrote:
I have been looking into heroku lately, they run on PostgreSQL -
https://postgres.heroku.com/postgres
Went out to lunch with a guy who worked for
On 09/04/2012 12:48 PM, Aram Fingal wrote:
> So, are you saying that if I do something like this:
>
> copy(crosstab(source_sql, category_sql)) to '/output.csv' with csv;
>
> Then I don't have to list what the columns are going to be? In other
> words, I can skip the "AS (...)" clause which is sh
On Sep 4, 2012, at 3:26 PM, Joe Conway wrote:
> On 09/04/2012 12:17 PM, Aram Fingal wrote:
>> On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
>>> see the documentation for Additional Supplied Modules, in your
>>> case tablefunc :
>>>
>>> http://www.postgresql.org/docs/9.1/static/tablefunc.html
On 09/04/2012 12:17 PM, Aram Fingal wrote:
> On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
>> see the documentation for Additional Supplied Modules, in your
>> case tablefunc :
>>
>> http://www.postgresql.org/docs/9.1/static/tablefunc.html
>
> I evaluated tablefunc about a year and a half ago
On Sep 4, 2012, at 2:51 PM, Vincent Veyron wrote:
> Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
>> hi all
>> How could i use crostab to display variable number of columns. in the output
>> There could be variable number of columns
>
> see the documentation for Additional Supplie
This is really good feature (crostab) to implement ..
Best Regards,
Dinesh
manojadinesh.blogspot.com
On Wed, Sep 5, 2012 at 12:21 AM, Vincent Veyron wrote:
> Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
> > hi all
> > How could i use crostab to display variable number of column
Le mardi 04 septembre 2012 à 08:39 -0700, punnoose a écrit :
> hi all
> How could i use crostab to display variable number of columns. in the output
> There could be variable number of columns
see the documentation for Additional Supplied Modules, in your case
tablefunc :
http://www.postgresql.o
Andy Yoder wrote:
> I would like the community's input on a topic. The words "too far
> out of the mainstream" are from an e-mail we received from one of
> our clients, describing the concern our client's IT group has
> about our use of PostgreSQL in our shop. The group in question
> supports
Now that 9.2 supports index-only scans, I'm curious what possibilities
this opens up in the future.
It seems to me that the next logical step is to allow a user to put
all columns into the index, at which point you would no longer even
need the heap table. Oracle calls this "index-organized table
On Tue, Sep 4, 2012 at 11:28 AM, Mike Christensen wrote:
> On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak wrote:
>> I have been looking into heroku lately, they run on PostgreSQL -
>>
>> https://postgres.heroku.com/postgres
>
> Went out to lunch with a guy who worked for Redfin as well. I guess
> the
On Mon, Sep 3, 2012 at 3:38 PM, Geert Mak wrote:
> I have been looking into heroku lately, they run on PostgreSQL -
>
> https://postgres.heroku.com/postgres
Went out to lunch with a guy who worked for Redfin as well. I guess
they're all Postgres over there too..
--
Sent via pgsql-general mail
Has anyone tried developing a PLR procedure to do the equivalent of crosstab
but using the Reshape library from R? The reason I ask is that I have been
extracting tables like this with an R script, using RPostgreSQL, then functions
from Reshape and writing the output to a .csv file. I wonder i
On 08/31/2012 01:05 PM, Andrew Sullivan wrote:
..Anyone who thinks that
MySQL, with its sketchy guarantees of data integrity and persistence,
is mainstream-acceptable but Postgres isn't because they haven't read
about it in InfoWorld
And if they want to read about it in InfoWorld, they can:
Hi ,
I believe, we need to have a Dynamic SQL for this to generate the dynamic
Crostab.. I have tried the same earlier and wrote the below Calendar Query
for the year 2011 including holidays.
Crostab Example
=
select
min(case when extract(month from d.dd)= 1 then
'Jan'
when extract(mo
hi all
How could i use crostab to display variable number of columns. in the output
There could be variable number of columns
Regards
Punnoose
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/crosstab-tp5722632.html
Sent from the PostgreSQL - general mailing list archiv
On Tue, Sep 4, 2012 at 6:57 AM, Rebecca Clarke wrote:
> Returns 0 rows.
how in the world did you get yourself in that situation?
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Sep 4, 2012 at 2:59 AM, Alexander Farber
wrote:
> Hello, thank you for your replies and sorry for the delay in my replying -
>
> On Thu, Aug 30, 2012 at 4:45 PM, Scott Marlowe
> wrote:
>> On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe
>> wrote:
>>> users, and currently work_mem is set
Hi there
Postgresql 8.4.
I keep getting this error multiple times when I tried to access the
pg_catalog in pg_admin:
Cache lookup failed for text search parser 3722.
The logs show that the query that was being executed was: (example is one
of many)
SELECT
(SELECT t.alias FROM pg_ca
On Tue, Sep 4, 2012 at 3:28 AM, Rebecca Clarke wrote:
> Hi there,
>
> I'm running postgresql 8.4 on a debian system. I have a database that has
> no object identifier types and functions in the pg_catalog,
> e.g. regclass, regclassout.
>
>
> What's the best way to get these in to this database?
On 09/04/2012 02:15 PM, Harshitha S wrote:
Hi,
Can Latch - that postgres already uses, be used to achieve the same?
With a quick look at latches I'm not sure what that'd have to do with
file change notification.
Magnus's suggestion to use a signal - especially as one is already
understood
Albe Laurenz wrote:
Himanshu Joshi wrote:
I am getting a below mentioned strange error while logging
into
postgres from linux command prompt. It is working fine with
GUI(pgAdmin
III). I am using postgres version 8.4SS.
Himanshu
# cd /opt/PostgresPlus/8.4SS/
# bin/p
Returns 0 rows.
On Tue, Sep 4, 2012 at 11:41 AM, Pavan Deolasee wrote:
>
>
> On Tue, Sep 4, 2012 at 3:58 PM, Rebecca Clarke wrote:
>
>> Hi there,
>>
>> I'm running postgresql 8.4 on a debian system. I have a database that has
>> no object identifier types and functions in the pg_catalog,
>> e.g.
On Tue, Sep 4, 2012 at 3:58 PM, Rebecca Clarke wrote:
> Hi there,
>
> I'm running postgresql 8.4 on a debian system. I have a database that has
> no object identifier types and functions in the pg_catalog,
> e.g. regclass, regclassout.
>
>
Are you sure you don't have them ? I thought regclass is
Hi there,
I'm running postgresql 8.4 on a debian system. I have a database that has
no object identifier types and functions in the pg_catalog,
e.g. regclass, regclassout.
What's the best way to get these in to this database? I don't want to
upgrade postgresql.
There are other databases on the
Basically, I have several production databases with various data, and I have a
reports database that grabs all necessary data once a day.
Now, there is is a new requirement to have some of the data available in the
reports database as soon as it is inserted in the production database.
Specifica
On Tue, Sep 4, 2012 at 2:49 PM, Segato Luca wrote:
> Dear Ashesh Vashi
>
> Here enclose the installation log file.
>
> The operating system is Microsoft windows vista Business service pack 2
> language Italian
>
Looks like the vbscript engine is missing or misconfigured on your system:
P
Dear Ashesh Vashi
Here enclose the installation log file.
The operating system is Microsoft windows vista Business service pack 2
language Italian
Thank for your help,
Best regards
Da: Ashesh Vashi [mailto:ashesh.va...@enterprisedb.com]
Invia
On Tue, Sep 4, 2012 at 10:59 AM, Alexander Farber
wrote:
> I'll try changing work_mem to 2MB first - once I upgrade the RAM.
And then I'll increase it up to 16MB every day as Scott proposed.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
Yvon Thoraval wrote:
> on my computer I had a disk probleme, then i had to reinstall the system
> (Xubuntu 12.04).
> I've backuped some parts of the disk, namely /etc, /var and /home.
> I wonder if I'm able to recover my past databases in the
> /var/lib/postgresql/9.1/ backup.
> If yes, how ?
If
Hello, thank you for your replies and sorry for the delay in my replying -
On Thu, Aug 30, 2012 at 4:45 PM, Scott Marlowe wrote:
> On Thu, Aug 30, 2012 at 8:42 AM, Scott Marlowe
> wrote:
>> users, and currently work_mem is set to 1M (the default.) If you
>> increase that to 16M, that'd be max
Hi,
On Tue, 2012-09-04 at 09:49 +0200, Johannes Segitz wrote:
>
> i'm currently working on a project to secure a webapplication with
> SELinux and I'm interessted
> in SEPostgreSQL. Is this project still alive? I couldn't find any
> information besides
> http://wiki.postgresql.org/wiki/SEPostgre
Hello,
i'm currently working on a project to secure a webapplication with
SELinux and I'm interessted
in SEPostgreSQL. Is this project still alive? I couldn't find any
information besides
http://wiki.postgresql.org/wiki/SEPostgreSQL_Introduction
Is anyone actively using/developing SEPostgreSQL?
On Mon, Sep 3, 2012 at 8:30 AM, Harshitha S wrote:
> Hi,
>
> We are trying to introduce a thread that monitors the creation of the
> trigger_file. As and when the file is created, the process that monitors
> postgres server needs to be notified through the inotify API.
>
> This is to reduce the 3-
64 matches
Mail list logo
