Grant Fisher writes:
> I am running postgresql 9.3 (installed via the
> apt.postgresql.orgrepository) on Ubuntu 12.10. I just upgraded from
> 9.2 on a dev machine, and
> when looking through the logs, I noticed that there were a lot of entries
> stating "LOG: setsockopt(TCP_KEEPIDLE) failed: Inval
Kevin Grittner-5 wrote
> The checkpointer process is responsible for creating safe points
> from which a recovery can begin; the background writer tries to
> keep some pages available for re-use so that processes running
> queries don't need to wait for page writes in order to have free
> spots to
Hello,
I am running postgresql 9.3 (installed via the
apt.postgresql.orgrepository) on Ubuntu 12.10. I just upgraded from
9.2 on a dev machine, and
when looking through the logs, I noticed that there were a lot of entries
stating "LOG: setsockopt(TCP_KEEPIDLE) failed: Invalid argument".
I was won
Kevin Goess writes:
>> Now, the only way to get to a zero selectivity estimate for var = const
>> is if the planner believes that the pg_stats most-common-values list
>> for the column is complete, and the constant is nowhere in the list.
>> So one plausible explanation for the change in behavior
Thanks for the reply!
Your analysis matches everything I see here, so what you say is probably
the case. As to why it changed for us with the 9.0 => 9.2 upgrade, I also
don't know--the change was pretty dramatic though. Since we've compensated
for it, and since you say the current behavior is act
On 11/11/13, 1:33 AM, Jeffrey Walton wrote:
> The analyzer is reporting some findings, and some of the findings look
> legitimate.
We have been tracking clang scan-build results for some time, and fixed
quite a few of them. Most of the remaining ones are false positives.
Maybe there are still a f
Kevin Goess writes:
> We noticed a big change after upgrading from 9.0 to 9.2. For
> *yesterday's*date, the query plan is fine, like you'd expect
> articles_1=> explain (analyze, buffers) select 1
> from hits_user_daily_count
> where userid = 1590185 and date = '2013-07-30';
> QU
On Tue, Nov 12, 2013 at 4:17 PM, Brian Crowell wrote:
> On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
> wrote:
> > I'm looking forward your patch.
> > Npgsql source can be found at github.com/npgsql/Npgsql
>
> I figured out the username issue, and so I've sent a pull request:
> https
Jayadevan M wrote:
> What are the real differences between the bgwriter and
> checkpointer process? Both of them write data from the buffer to
> the data files, right? Is it just a matter of 'when' they write?
The checkpointer process is responsible for creating safe points
from which a recovery
On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
wrote:
> I'm looking forward your patch.
> Npgsql source can be found at github.com/npgsql/Npgsql
I figured out the username issue, and so I've sent a pull request:
https://github.com/npgsql/Npgsql/pull/95
I encountered an issue where con
Something else that causes a similar error is if the PostgreSQL daemon is
restarted in the middle of logging a query. The log line is truncated and the
next log line starts straight after the truncated line without even a newline
in between. The problematic line can be many lines before where
On Tue, Nov 12, 2013 at 10:03 AM, Christian Ullrich
wrote:
> Pseudocode:
>
> n = GetUserNameEx(NameSamCompatible)// "logon screen" case
> NameTranslate.Set(ADS_NAME_TYPE_NT4, n)
> n = NameTranslate.Get(ADS_NAME_TYPE_DOMAIN_SIMPLE) // "official" case
> n = n.CutAtTheAtSign(
On Tue, Nov 12, 2013 at 8:46 PM, gajendra s v wrote:
> Hi All,
>
> How to remove {} from output
>
> I am using below query
>
> select (xpath('//Grading_Automated',(select xmlgrading from km_course_mast
> where id='10'))) from km_course_mast where id='10'
>
> The out is below
>
> "{"
>
> "
* From: Brian Crowell
> On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich
> wrote:
> >> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell
> wrote:
> >> * If I don't specify my username, Npgsql sends it in lowercase
> "bcrowell"
> >
> > Hmm. That is related one problem I've been having with SSPI
On Mon, Nov 11, 2013 at 11:56 PM, Christian Ullrich
wrote:
>> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell wrote:
>> * If I don't specify my username, Npgsql sends it in lowercase "bcrowell"
>
> Hmm. That is related one problem I've been having with SSPI auth from
> libpq/ODBC. The database t
Hi All,
How to remove {} from output
I am using below query
select (xpath('//Grading_Automated',(select xmlgrading from km_course_mast
where id='10'))) from km_course_mast where id='10'
The out is below
"{"
"}"
Thanks,
Gajendra
On Tue, Nov 12, 2013 at 9:13 AM, Brian Crowell wrote:
> net ads keytab add postgres/machinen...@realm.com -U DOMAIN\Administrator
> net ads keytab add postgres/machinename.domain@realm.com -U
> DOMAIN\Administrator
D'oh! These should be:
net ads keytab add postgres/machinen...@realm.co
On Tue, Nov 12, 2013 at 5:45 AM, Francisco Figueiredo Jr.
wrote:
> It would be awesome if you could write a little guide about how to configure
> PostgreSQL to work with sspi authentication from Windows.
> I could add it to our Npgsql user manual...
A guide will have to wait until I do all this a
On Tue, Nov 12, 2013 at 6:56 AM, Christian Ullrich wrote:
> * From: Brian Crowell
>
> > On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell
> wrote:
> > > I think I'm getting closer though. I have psql on Windows successfully
> > > authenticating, so I can't be too far off.
> >
> > Got it.
>
> Great!
Em 12/11/2013 03:37, "Brian Crowell" escreveu:
>
> On Mon, Nov 11, 2013 at 10:51 PM, Brian Crowell wrote:
> > I think I'm getting closer though. I have psql on Windows successfully
> > authenticating, so I can't be too far off.
>
> Got it.
>
> The NpgsqlPasswordPacket class has a bug: a utility f
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M wrote:
> Hi,
> What are the real differences between the bgwriter and checkpointer
> process? Both of them write data from the buffer to the data files, right?
> Is it just a matter of 'when' they write?
>
I believe, "Checkpoint" is one of the responsi
On Tue, Nov 12, 2013 at 6:57 AM, Jayadevan M wrote:
> Hi,
> What are the real differences between the bgwriter and checkpointer
> process? Both of them write data from the buffer to the data files, right?
> Is it just a matter of 'when' they write?
> Regards,
> Jayadevan
>
Expect some corrections
22 matches
Mail list logo
