_MAX / 2,
1645 NULL, NULL, NULL
So which one is correct?
Also, what exactly is the default value? The manual says that the default
is 128MB while the min is 128KB. But from the code, you can clearly see
that it's not the case.
Thank you very much!
Best regards,
Tianyin
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
Thanks a lot, Jeff!
On Wed, Nov 14, 2012 at 11:59 AM, Jeff Janes wrote:
> On Wed, Nov 14, 2012 at 12:12 AM, Tianyin Xu wrote:
> > Hi, Postgresql,
> >
> > I want to understand how the query optimizers affect the output of the
> > window functions.
>
> Use &q
Hi, Postgresql,
I want to understand how the query optimizers affect the output of the
window functions.
For example, set "cpu_tuple_cost = 50" in postgresql.conf and start the
server, I apply the regress test (make installcheck). The test of window
function fails.
Checking the diff and I found
On Thu, Nov 8, 2012 at 6:40 PM, Alvaro Herrera wrote:
> Tianyin Xu wrote:
> > Ok, I agree that "2147483647" is not a reasonable setting. But what's
> the
> > definition of "reasonable"? I just want to study the impact of the
> setting
> > so I
Thanks, Craig.
That makes sense. Yes, it's quite a number of work to do. :-) I'll take a
look at the comments and code and try to understand it.
T
On Thu, Nov 8, 2012 at 6:28 PM, Craig Ringer wrote:
> On 11/09/2012 09:37 AM, Tianyin Xu wrote:
> > Thanks, Craig,
> >
ex", "inherit", "join", "stats".
When you give users the flexibility of configurations, you cannot say all
the values mismatching with your expectations are not allowed. In fact the
system allowed such settings.
T
On Thu, Nov 8, 2012 at 6:10 PM, Bruce Momjia
at 3:29 PM, Craig Ringer wrote:
> On 11/09/2012 03:28 AM, Tianyin Xu wrote:
>
> Thanks a lot, Pavel, Jeff, Andres!
>
> I just changed the configuration file, postgresql.conf.
>
> Using the default one, all the regress tests are passed (so it should not
> be the block size?
| t
(1 row)
-- End of Stats Test
--- 108,114
WHERE st.relname='tenk2' AND cl.relname='tenk2';
?column? | ?column?
--+--
! t| f
(1 row)
-- End of Stats Test
==========
O
On Wed, Nov 7, 2012 at 10:00 PM, Pavel Stehule wrote:
> 2012/11/7 Bruce Momjian :
> > On Tue, Nov 6, 2012 at 09:24:19AM +0100, Pavel Stehule wrote:
> >> 2012/11/6 Tianyin Xu :
> >> > Thanks, Pavel!
> >> >
> >
What I experienced when submitting a bug report is
Forbidden (403)
CSRF verification failed. Request aborted.
More information is available with DEBUG=True.
t
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
I see. Thanks a lot for the explanation!
Tianyin
On Tue, Nov 6, 2012 at 8:32 AM, Magnus Hagander wrote:
> On Tue, Nov 6, 2012 at 5:25 PM, Jeff Janes wrote:
>
>> On Tue, Nov 6, 2012 at 3:16 AM, Magnus Hagander
>> wrote:
>> > On Tue, Nov 6, 2012 at 9:08 AM, Tianyi
Thanks again!
t
On Tue, Nov 6, 2012 at 12:24 AM, Pavel Stehule wrote:
> 2012/11/6 Tianyin Xu :
> > Thanks, Pavel!
> >
> > I see. So the regress test cases are the complete functional testing? Am
> I
> > right?
>
> yes
>
> >
> > (I t
Thanks, Pavel!
I see. So the regress test cases are the complete functional testing? Am I
right?
(I thought they're test cases for regression)
T
On Tue, Nov 6, 2012 at 12:00 AM, Pavel Stehule wrote:
> hello
>
> 2012/11/6 Tianyin Xu :
> > Hi,
> >
> > Does an
ot valid, the
user should stop because it clearly means the path is misconfigured.
Is there any concern here? Otherwise I would suggest and provide a patch to
check the validity of the "ident_file" like what pg is doing for
"data_directory" and "hba_file".
Thanks a lot!
Tianyin
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
Hi,
Does anyone know whether PostgreSQL has complete functional test cases? And
where can I find them?
Currently, I only find some test cases in "PG_SOURCE/src/tests", but it
seems that they are pretty simple and do not cover a lot of features of
PostgreSQL.
Thanks a lot!
Tianyin
-
AM, Tom Lane wrote:
> Chris Angelico writes:
> > On Mon, Oct 29, 2012 at 5:44 PM, Tianyin Xu wrote:
> >> I still wonder why application_name appears in the configuration file
> if it
> >> cannot take effort :-P
>
> > Not sure what you mean by that, but my po
Got it! Thanks, Chris!
I still wonder why application_name appears in the configuration file if it
cannot take effort :-P
T
On Sun, Oct 28, 2012 at 11:29 PM, Chris Angelico wrote:
> On Mon, Oct 29, 2012 at 5:22 PM, Tianyin Xu wrote:
> > Thanks a lot, Chris!
> >
> > Yes,
f the local
log messages?
T
On Sun, Oct 28, 2012 at 10:27 PM, Chris Angelico wrote:
> On Mon, Oct 29, 2012 at 4:18 PM, Tianyin Xu wrote:
> > However, I have the following configuration settings in postgresql.conf
> >
> > application_name = 'mypostgres'
> >
log.c:6112
[] LOG: 0: autovacuum launcher started
[] LOCATION: AutoVacLauncherMain, autovacuum.c:407
[] LOG: 0: database system is ready to accept connections
[] LOCATION: reaper, postmaster.c:2408
Did I miss something?
Thanks a lot!
Tianyin
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
log.c:6112
[] LOG: 0: autovacuum launcher started
[] LOCATION: AutoVacLauncherMain, autovacuum.c:407
[] LOG: 0: database system is ready to accept connections
[] LOCATION: reaper, postmaster.c:2408
Did I miss something?
Thanks a lot!
Tianyin
--
Tianyin XU,
http://cseweb.ucsd.edu/~tixu/
20 matches
Mail list logo
