On Tue, Mar 4, 2014 at 1:13 PM, Sameer Kumar wrote:
>
> On Tue, Mar 4, 2014 at 2:57 PM, Adarsh Sharma wrote:
>
>> I tried creating simple and gin indexes on the column(t_ids) but still
>> not helping. Anyone has any idea or faced this before. Postgresql version
>> is 9.2.
>>
>
> have you done a va
On Tue, Mar 4, 2014 at 4:19 PM, Adarsh Sharma wrote:
> Is dere any way i can rewrite the query so that i need not to set
> seqscan-off, because i dont want to embed one more line in application
> code and also dont want to change global setting in postgresql.conf to
> disable seqscan.
>
You can
I wonder how to quickly recovery failed master? If I directly startup the
failed master as slave ( assign proper parameter), is there any problem? For
example, I don't do any copy operation in script of
recovery_1st_stage_command and recovery_2st_stage_command.
According to this document:
https://
2014-03-04 10:19 GMT+02:00 Adarsh Sharma :
>
> PLAN
>
>
> -
> HashAggregate (cost=10651634346.70..10651780073.12 rows
Hello,
I would like to log statements that modify a small subset of tables in a
databases.
(not all tables, because the log files become too big in that case and I
also worry about performance)
I currently use log_statement='mod' but I didn't find a way to limit
this to the set of tables I want
So, there's no way to do this?
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Read-tables-of-sql-server-with-postgres-tp5793046p5794581.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general
On Tue, Mar 4, 2014 at 6:48 AM, loref85 wrote:
> So, there's no way to do this?
You might want to give jdbc-fdw a try. not sure what's wrong with
odbc -- looks like a driver mismatch issue.
merlin
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your s
Le 2014-03-03 à 10:53, Adrian Klaver a écrit :
> On 03/02/2014 08:48 PM, François Beausoleil wrote:
>> Hi all,
>>
>> I have four roles involved:
>>
>> meetphil - the database owner, should not login
>> mpwebui - the role the web application logs in as, should have very limited
>> privileges, b
On 03/04/2014 04:48 AM, loref85 wrote:
So, there's no way to do this?
In your original post you said you found a version of odbc_fdw that
compiled for 9.2+, but hung on a select due to this error:
ERROR: odbc_fdw::odbcGetTableSize: Could not retrieve table size
Have you tried to contact t
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
error
fm_db_Server1-# insert into m
On Mar 4, 2014, at 2:19 AM, David Janssens wrote:
> Hello,
> I would like to log statements that modify a small subset of tables in a
> databases.
> (not all tables, because the log files become too big in that case and I also
> worry about performance)
> I currently use log_statement='mod' bu
Tom Lane wrote:
> Albe Laurenz writes:
>> Is there anything that "varchar_pattern_ops" is needed for that
>> "text_pattern_ops" cannot provide?
>
> Lack of surprise? If you're creating a pattern index on a varchar column,
> you'd likely expect to need to mention varchar_pattern_ops.
>
> The idea
ajay writes:
> hello team ,
> i am trying to enter this insert command in postgres
> insert into mmsuper.notification
> values('101','12','13','Øب|welcome|à¤à¤ªà¤à¤¾à¤¸à¥à¤µà¤¾à¤à¤¤à¤¹à¥','bye','goodbye','low
> balance',5);
> now when i am trying to paste this in postgres in Solaris , it
On 03/04/2014 03:03 AM, ajay wrote:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am trying to paste this in postgres in Solaris , it is giving me
er
On 03/04/2014 07:39 AM, Adrian Klaver wrote:
CCing list:
On 03/04/2014 03:03 AM, ajay wrote:
hello team ,
i am trying to enter this insert command in postgres
insert into mmsuper.notification
values('101','12','13','حب|welcome|आपकास्वागतहै','bye','goodbye','low
balance',5);
now when i am try
Hello,
I ran into trouble with an xpath expression on a large XML file:
SELECT id, xpath('//tei:div/descendant::tei:head/text()', x, ARRAY[ARRAY['tei',
'http://www.tei-c.org/ns/1.0']]) AS stuff FROM test WHERE id=1;
returns:
ERROR: could not parse XML document
DETAIL: line 491482: internal e
On 03/04/2014 06:00 AM, François Beausoleil wrote:
Le 2014-03-03 à 10:53, Adrian Klaver a écrit :
On 03/02/2014 08:48 PM, François Beausoleil wrote:
Hi all,
I have four roles involved:
meetphil - the database owner, should not login
mpwebui - the role the web application logs in as, should
thanks for the reply ,..
When i am trying to enter anything else other then some Arabic , Hindi ..
that case it does not give this error.
like if i enter..
insert into table values('welcome',1);
then it does not give any error and get successfully
Thanks
--
View this message in context:
http
Hi all:
I have a table that has multiple records for a single owner_id. I'm able to
use array_arg to combine the records into a single row, which works fine. I'm
using this sql:
select owner_id, array_agg(trim(maplot)), array_agg(revallandvalue +
revalbuildingvalues) from parcel group by own
On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett wrote:
> Hi all:
>
> I have a table that has multiple records for a single owner_id. I'm able to
> use array_arg to combine the records into a single row, which works fine.
> I'm using this sql:
>
> select owner_id, array_agg(trim(maplot)), array_agg(
David Janssens writes:
> Hello,
> I would like to log statements that modify a small subset of tables in
> a databases.
> (not all tables, because the log files become too big in that case and
> I also worry about performance)
> I currently use log_statement='mod' but I didn't find a way to limit
Roy Anderson wrote:
> We have an OLTP database and no data warehouse. We are currently
> planning out a build for a data warehouse however (possibly using
> Hadoop). "X" is recommending that we convert our current,
> normalized OLTP database into a flattened Star Schema.
I'm not going to repeat
On Tue, Mar 4, 2014 at 2:15 PM, Kevin Grittner wrote:
> Roy Anderson wrote:
>
>> We have an OLTP database and no data warehouse. We are currently
>> planning out a build for a data warehouse however (possibly using
>> Hadoop). "X" is recommending that we convert our current,
>> normalized OLTP da
Merlin Moncure-2 wrote
> On Tue, Mar 4, 2014 at 1:49 PM, Owen Hartnett <
> owen@
> > wrote:
>
>> It looks like I should be able to use the window function to do this,
>> but
>> I've been unsuccessful. The following runs, but doesn't seem to have any
>> effect:
>>
>> select owner_id, array_agg(
On 03/04/2014 01:40 PM, Merlin Moncure wrote:
On Tue, Mar 4, 2014 at 2:15 PM, Kevin Grittner wrote:
Roy Anderson wrote:
We have an OLTP database and no data warehouse. We are currently
planning out a build for a data warehouse however (possibly using
Hadoop). "X" is recommending that we conv
On Tue, Mar 4, 2014 at 9:19 PM, David Janssens wrote:
> Hello,
> I would like to log statements that modify a small subset of tables in a
> databases.
> (not all tables, because the log files become too big in that case and I
> also worry about performance)
> I currently use log_statement='mod' bu
On Tue, Mar 4, 2014 at 6:26 PM, leo wrote:
> I wonder how to quickly recovery failed master? If I directly startup the
> failed master as slave ( assign proper parameter), is there any problem?
Yep, if the master has got ahead of the slave in term of WAL replay
where WAL forked after the slave pro
I find a solution to short the recover time by configure parameter
Synchronous Transfer. Refer to :
https://wiki.postgresql.org/wiki/Synchronous_Transfer.
But I don't which postgreSQL will enable this parameter, I install
9.3.3-1 on redhat, but I don't find this parameter in postgresql.conf.
On Wed, Mar 5, 2014 at 2:14 PM, leo wrote:
>I find a solution to short the recover time by configure parameter
> Synchronous Transfer. Refer to :
> https://wiki.postgresql.org/wiki/Synchronous_Transfer.
>But I don't which postgreSQL will enable this parameter, I install
> 9.3.3-1 on redha
29 matches
Mail list logo
